It's valid query with valid WHERE clause. What's actual query and what error do you get?
>
>What should I use in the SQL Select (from VFP) that has ">" between two fields or field expressions. For example, I get error when using the following:
>
>
>select * from mytable where (field1 > field2)
>
>
--sb--