>I imported data from excel to a table.
>some fields have spaces on the left side. I replaced the field by ALLTRIM(field) but the left space did not go away as it should do.
>
>Then, I check for the LEFT(field,1) =" " but it failed. I can see the empty space but I don't know why VFP does not think it is a space. Any idea?
>
>Mo
It must be some unprintable character.
?asc(left(field,1))
If it's not broken, fix it until it is.
My Blog