Hi, try this !
SELECT * FROM mydbf WHERE field > 0
if the field is char, VAL(field)
> myfield = name of field to search
if myfield is other table, you need include the table in SELECT and use a field for relation with mydbf using WHERE cluse
excuse the english
>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
>
>What is my syntax error?
>
>Thanks, Randy