>Hi. VFP7 user. I was attempting to find every record that had a quantity of > 0 in a particular field. I tried:
>
> myfield = name of field to search
> SELE * FROM mydbf WHERE EVAL('&myfield')>0
Try
SELECT * FROM mydbf WHERE EVAL(myfield) > 0
or
SELECT * from mydbf WHERE &myfield > 0