I want to know if it is valid to put an expression on the left hand side of a relational operator in an SQL statement. Foxpro doesn't complain but an associate says it is worng and could produce questionable results.
Here is an example of what I am talking about.




select * from table1 where field1 * var1 >= 100 into cursor temp1


field1 is a numeric field in table1
var1 is a numeric variable