>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
Cindy,
SET EXACT doesnt affect how comparisons between strings of different lengths are made with the = operator in in Visual FoxPro SQL commands,
SET ANSI does.
--sb--