>I have a field that is defined as a caracter, and I want to detect a space in the used part of the field (not the space at the end of the text). is there a difrence in the definithion of the two kinds of spaces? if not how can I request the space in the first 10 letters only?
>example: 06 7129361. I want to get (by select * from) only lines that there is a space in the first ten characters.
IF ( SPACE(1) $ ALLTRIM(myfield))
? "There's space bettwen characters"
...
ELSE
...
ENDIF
--sb--