Randy,

Read in Help about SET("Exact"). You can use CustNo == '12345' or ALLTRIM(CustNo) = '12345' to get only those with '12345', and not '123' or whatever.


>An SQL statment such as: SELE * FROM customers WHERE custno = '12345' also pulls up records with an *empty* custno filed. Why?
>Thanks, Randy