Hi,

I need to modify the query below:

Select name, "\kk\", address from table where ID = 1

I want the output to be

name \kk\name address

I want the constant value to be prefixed to the column value.

Please help.

Thanks

This should work.

Select name as [name], '\kk\' + name as [name2], address from table where id =1

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.