Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Select FirstName + ' ' + secondName from Table
- SELECT FirstName + ISNULL(' ' + SecondName, '') + ' age(' + CONVERT(nvarchar,age) + ')' from Table
- select cast( FirstName as varchar)+' '+cast( secondName as varchar) from table
Add Comment
Please, Sign In to add comment