General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Is this a valid SQL expression
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only