>Hi,
>
>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)
>

>
>Thank you for any suggestions.

In this particular sample the syntax is correct. Are you sure that both fields are of the same type ? What are the types of these fields, may be > is not allowed for the particular type you're trying it.