How to add single inverted comma after column name

Question

I want to print the statement like [Emp_name's salary is .....] ex.- Aniket's salary is...

What will be the syntax for this?

I have tried this SQL:

select empname + 's''salary is' + cast(salary as varchar) 
from emp

but it's not working

"not working" is not a good problem description. Do you get any errors? Then please include them. Is the output not what you want? Then show and explain that — Hans Keﬆing, Apr 15 '23 at 06:12

score -1 · Accepted Answer · answered Apr 15 '23 at 05:32

-1

select empname+ '''s salary is' + cast(salary as varchar) from emp

answered Apr 15 '23 at 05:32

1 Answers1