Query Sql

Trips

Well-known member
Joined
Aug 7, 2010
Messages
2,788
hi,
I have to concate a number to a field value, example (123 to EMPLID value) and display as one column. I used CONCAT but SQl server and got error... like
"CONCAT is not a recognized built-in function name.<br/>
[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the keyword AND"
what is the correct syntax.

Rao.




View the full article
 
Back
Top