Hi Patric,

Another way would be to create variables A to Z:

A = -1
B = -2
*...

then run the SELECT statement like this:

Select * from mytable where evaluate(myfield) < 2

This query can't be optimized, though. Similarly, you can use something like

WHERE AT(Alltrim(myField)+" ","A  B  C...9  10 11 12") < AT("2 ","A  B...")