Can QV use variables in [SQL SELECT] ?

[mokitsu61]

Hi,

Can QV use variables in [SQL SELECT]?

e.g.

SET vCondition = '';

SQL SELECT *

FROM TableName

WHERE A = $(vCondition);

[mayankraoka · Accepted solution]

You can also use below:

Let vCondition = '';

SQL SELECT *

FROM TableName

WHERE A = '$(vCondition)'

Regards,

Mayank

[brooksc57]

you wouldn't believe how hard this was to find.  I kept searching preceding load with sql select variable and similar things to that...thanks so much for your post.  it will greatly reduce the punishment of returning too many useless records!!!