|
Subject:
|
Append a constant value to a column value
|
|
Posted By:
|
kkrish
|
Post Date:
|
9/21/2006 5:38:38 PM
|
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
|
|
Reply By:
|
dparsons
|
Reply Date:
|
9/21/2006 7:51:57 PM
|
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.
|
