Remove leading space

[mystuff]

I am trying to use a query to remove leading spaces. I tried to use the TRIM command but it does not seem to do anything.

The field name that I am trying to trim is: [Product Name]

When I put the following in the column of a select query, I still have the leading space.

NewProductName:Trim([Product Name])

Any ideas?

 

[ByteMyzer]

How about:
[tt]NewProductName:LTrim([Product Name])[/tt]

 

[JonFer]

Trim() works on both sides so maybe it is not a space there. It could be a non-displayable character. Highlight the leading "space" from one of the affected fields and then copy/paste it into Word and turn on the "show hidden characters" option.

 

[mystuff]

JonFer, you were absolutely right, it was not a space. Thanks alot!

 

[jsanbor1]

anyone know how to remove the non-displayable characters?

 

[JonFer]

You can use a built-in function to check a single character's ASCII code. If you want to check every character in a string, you should write your own function.

Somewhere in Access help is the ASCII table so you can determine what's what.

John

http://www.interautomateconsulting.com