>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.
If it's not broken, fix it until it is.
My Blog