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?
Thank you
Chaim