Removing leading spaces

[Robin Chapple]

I have inherited a table which includes fields with leading spaces. I
can trim() the space in reports but how do I clean the original data
using an update query?

Thanks,

Robin Chapple

 

[Van T. Dinh]

UPDATE YourTable
SET [YourField] = Trim([YourField])

 

[Robin Chapple]

Thank Van,

I missed the double brackets.

Cheers.