Hi Stephen,
I don't know Oracle, but what about
UPDATE equipment SET description=LTRIM(description) WHERE description like ' %'
>Hello All
>
>
>Quick question, I have been handed a oracle database that I can only access via SQL statements, in one of my tables I have a field called description and over 37,000 of the recorder begin with a space;
>
>“ CPU, DESKTOP 1.5ghz”
>
>I can do a SQL statement to retrieve select * from equipment where equipment.description like ‘ %’
>
>But to save my life I can not figure out how to do a SQL UPDATE to replace all of the description with description minus the leading space
>
>Any help in any way will be greatly appreciated
>
>Thanks
>Stephen McLaughlin