Removing spaces from the left of an address

[gwen]

How do I remove spaces if any from text in a column on the
left of data?

 

[Ken Snell]

Run an update query that uses the LTrim function:

UPDATE TableName SET [FieldName] =
LTrim{[FieldName]);