>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
You can rushmore optimize this if you changed it to WHERE Field1 >= 100/Var1 as long as you have an index on Field1
Mark McCasland
Midlothian, TX USA