Update record and remove leading blank 1

[kskid]

I use the following select to pull the erroneous records with leading blanks but can't quite figure out how incorporate it into an update transactions

select leftrim(fname,' ')
from master
where substr(fname,1,1) = ' '
and fname is not null

 

[carp]

UPDATE master SET fname = LTRIM(fname) WHERE fname IS NOT NULL;

 

[kskid]

Worked great!

Thanks! Worthy of a star!

-LW