Posted by strawberry on 10/13/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)

• Next in forum: Re: Trim the leading characters of a field
• Prev in forum: Re: please Help me out with this
• Thread view: Re: Trim the leading characters of a field

[Reply to this message]