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)

[Back to original message]