How to use Variable in Where Clause

[#1]

Hello All,

Need your help very urgent.

i have a something like below,

Load

Week

From ABC.QVD;

vWeek=max(Week)

Sellout:

Load *

From XYZ.QVD where Week<=$(vWeek);

When i run the above script, it says field not found.

Need your help on how to use variable in Where clause.

Thanks for your help

Thanks & Regards,

Venkat T

[rbecher]

Yeah, this might work mostly in a LOAD Where clause but maybe not in a SQL Select Where clause..

[tresesco]

Thanks Ralf.