Removing spaces from a lot of records at once

J

Josh

I would like to take my DB and somehow run an update
query (or something) to remove spaces from a field. There
are 3500 records and 2 fields that need this done and I
don't want to do them one at a time. Any suggestions??

Thanks in advance,

Josh
 
P

PC Datasheet

You can remove leading spaces, trailing spaces or both with the LTrim, RTrim or
Trim functions in an update query.
 
Top