Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2004-06-13 : 12:53:36
|
| I want to add to my sql statement to select a+[employeeid] as id.This should be the letter a concatenated with whatever the value of employeeid is. What is the correct syntax? |
|
|
gpl
Posting Yak Master
195 Posts |
Posted - 2004-06-13 : 12:58:52
|
| tryselect 'a' + convert(Varchar(25),[employeeid]) as idassuming employeeid is an integerGraham |
 |
|
|
|
|
|
sql statement syntax