Var in SQL

[imox]

Hello,

SELECT * FROM table;
WHERE  table.column [b]=[/b] "value"

how can I set the operator '=' in a variable?

 

[Olaf Doschke]

You could do macro substitution:

lcOperator = "=" && or "<" or ">=" etc
SELECT * FROM table WHERE  table.column &lcOperator "value"

Indeed it's not uncommon to put the whole where clause into a string variable lcWhere and then execute

SELECT * FROM table WHERE &lcWhere

Bye, Olaf.

 

[imox]

It works! Thanks a lot