Posted by das on 04/05/06 20:09

Or if you know that the first part of the string is always going to be
'PICTURE' then simply use this:

update ace
set PICTURE = left(PICTURE, 7)

• Next in forum: New to MS-SQL
• Prev in forum: Re: Problem concatenating column values into string...
• Thread view: Re: Reversing string concatenation

[Reply to this message]