Search:

Have a bit of an issue with this program. Firstly because I'm using the random function I need at least 4 characters to seed so I put a loop in the input to only continue when 4 or more characters...

Long story short, I've been shortlisted for an entry level position and they have asked to provide 2 solutions as a test prior to the interview. But its for Transact SQL so I will assume Windows SQL...

Hey that worked great. May I ask another question? Are you not allowed to have spaces when naming columns.

Your example

SELECT lastname + ', ' + firstname as fullname
FROM table

Works...

Really its that easy? I'm going to go modify my SELECT statement.

Thx

Is it possible utilizing a SQL statement to take 2 fields, such as firstname and lastname into another field called fullname combining the 2?

Thank you.

Really appreciate everyones help.

hmm Good question...But I have added some other stuff and 'strlen' does not work on the variable being a string.

hmmm. I just used str.length()

Well I got it too work like this but not sure if I am crossing any boundaries using a mixture of the char and string variable. But I still have to figure out to rmeove any spaces then build the...

Initalizing the variables seems to work as that example but trying it to use it with users input and using character arrays is a bit different. Let me go try something else and see..I need to be able...

I tried to work with those examples but I must be doing something wrong with passing strings and such, can't get it to compile.

Wow thanks Paul and James. Will go try that. I guess if I include the Namespace std, i can remove the std:.

Thanks again

Hello,

I am trying to learn C++ and running into a problem that I"m at a loss how to get started or basically finished.

Ok I am building a small C++ console app that takes input from a user and...