Posted by strawberry on 10/04/61 11:42

So you basically want to remove the first two characters in every row
in that column right? If so, I think what you want is this - but it
might not be right so IT IS VITAL THAT YOU BACK UP YOUR DATA BEFORE
DOING THIS!!!! YOU HAVE BEEN WARNED...

UPDATE table_name SET field_name = SUBSTRING(field_name_name,2)

[Back to original message]