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