Hello Borislay,
What if the number is '001234xxxx', also may not be optimizable;
How about
SELECT * FROM YourTable WHERE BETWEEN(YourTable.TableField,'0','9') INTO ...
bOB
>If I understood you right:
>
>SELECT * FROM YourTable WHERE VAL(YourTable.TableField) # 0 INTO ...
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'