> Select * from MyTable where ABS(MyField)>1;

Select * from MyTable where MyField > 1 OR MyField < -1;

:-)

Ivan
http://www.volny.cz/iprenosil/interbase