Posted by Ian Robinson on 10/13/33 11:42

Sorry to bother you again, but just so I understand this properly how would
I remove spaces from within a field which could be at random positions
within that field ?

i.e
R ERR3340
R DA 3025
STC345 AG

TIA
Ian

>
> UPDATE table_name SET field_name = SUBSTRING(field_name,2)
>

• Next in forum: Re: Trim the leading characters of a field
• Prev in forum: Re: Trim the leading characters of a field
• Thread view: Re: Trim the leading characters of a field

[Reply to this message]