Remove leading space

[Guest]

I have a Description field that has a " " for the first character. I need to
remove that leading space. I created a query to find the records with the
space but I'm not sure how to remove it.

For example - this is currently what the field looks like
4500-F-12/24D-612
and i need it to look like this (without the leading space)
4500-F-12/24D-612

 

[Joan Wild]

Check out LTrim in Help.

 

[Guest]

Use the LTrim function in an update query, e.g.

UPDATE [MyTable]
SET [Description] = LTRIM([Description]);

This will remove the leading spaces from the relevant rows, but leave the
others unchanged.

Ken Sheridan
Stafford, England

 

[Guest]

The easy way is to use an Update query with this as the Update To information