Removing spaces before a string (1 Viewer)

[ranch]

I am trying to remove spaces that are in several fields in a table. The spaces are only at the beginging, IOW Left of the string.

Table is "member1" & field is "address"

I have been using:

UPDATE member1 SET member1.address = LTrim$([address]);

without success.

What am I missing ?

Thanks in advance...

 

[Alexandre]

Strange.
This worked for me:
UPDATE member1 SET member1.address = LTrim([address]);

 

[ranch]

Alex,

I found the error in my ways.....I was creating the query and switching to "datasheet view" and seeing results come up, but the spaces were still there. I had done a similair query with a function to remove qoutes and would get the desired result by just switching views. I did not realize that "running" the query will give a different result than just switching from "design" to "datasheet" views in some cases. I am just learning this program.....thanks for checking it out.

Mike