Use “||” like so…
SELECT LastName||', '||FirstName
FROM [schema].[table]
If one of the columns is numeric you’ll probably want to convert to CHAR and TRIM like so…
SELECT LastName||', '||FirstName||' - '||TRIM(CHAR(EmplId))
FROM [schema].[table]
Please remember to subscribe to the newsletter to stay up to date!You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...
Thanks this post helped me
Awesome … it worked great!
Thanks!!! it worked to perfection…