Trim Space before String

[Steven547]

I have a bunch of records that have been imported into Access, but they all have a space before the string.

ie: " company...".

I want to remove the space so they resemble "company...". I know this is probably a real easy thing to do, but I can't figure it out. Anyone?

Thanks.

 

[Remou]

Try this (on a back-up first )

Update NameOfTable Set Company=Trim([Company])

 

[Steven547]

Yea...that actually works. I was just going to post that I think I figured it out. One other question though, if there is a "." before the record: ".company" How would I remove that "period"?

 

[PHV]

UPDATE yourTable
SET Company=Mid([Company],2)
WHERE Left([Company],1)='.'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886