I thought I tried that before, I must of worded it wrong cause your answer worked


Thank you very much


>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