Trim Spaces

[Garry]

Hi

I need to trim some reference numbers in the form of
B D AAA
D A BCD etc

too

BD AAA
DA BCD i.e. removing the first space

Thanks in advance, Garry
--

 

[Guest]

I suggest you take a backup copy of the table first.
Create a query based on your table and put just the Column to be updated in
it.
Change the query type to an update query and in the update to row put this

Replace([YourFieldName]," ","",1,1)