Query question?

[proe]

I have a little problem when I use this query.
What I am trying to do is pull out a list of records from a table:
A11
A12
A13
..
..
A19
..
..
A20
..
..
A121
A122
..

So when I write my query I say to give me whatever is between A11 to A18... and I was expecting A11,A12,A13...A18, but I am getting all those plus A121,A122,A123...A129
How can I avoid this.. please help.

 

[jwindon]

You are trying to do mathematical logics on a text field. You will need to separate the "A" out of the rest of the string. Look up extracting part of a string. If you don't find it, I'll spend some more time answering. Good luck.