Reply to Re: Trim the leading characters of a field
Posted by Ian Robinson on 03/21/06 10:12
Thank you
Regards
Ian
"strawberry" <zac.carey@gmail.com> wrote in message
news:1142603780.626139.12240@e56g2000cwe.googlegroups.com...
> There may be a simpler way but this should work...
>
> UPDATE table_name SET field_name = replace(field_name, ' ', '')
>