August 16, 2006 at 11:38 am
How do I concat the letter 'A' to the start of every string that is found in a column?
August 16, 2006 at 11:43 am
T-SQL string concatenation simply uses the '+' operator.
SELECT 'A' + YourColumnName
FROM YourTableName
August 16, 2006 at 11:48 am
Can I put that in an UPDATE statement?
Update: Sorry .... I can .... I need to go to bed I think.
August 16, 2006 at 1:02 pm
update mytable
set myfield = 'A' + myfield
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply