Hi, please help me, i'm totally helpless

short example:

i have table : CREATE TABLE TABLE1 (COLUMN1 VARCHAR(10))

there are some records in the table, for example :
"a"
"ab"
"abc"
...
"x"
"xa"
"xc"
"xd"


i fill SQL property with this statement
'SELECT COLUMN1 FROM TABLE1 ORDER BY COLUMN1';

after executing Locate('COLUMN1','x',[lo]) method, "xb" record is located,
not "x" that i expected in view of the fact that
there is ORDER BY clause in the statement

if AutoFatchAll property is True everything's fine,but i can't use this way
because of size of table

thanks
peter