>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.
>Who can help me?
If I understand your specifications correctly, you may want to combine both of Sergey's suggestions:
space(1) $ alltrim(left(MyField, 10)).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)