Use ' in where clause of load

[#1]

Hi,

I am trying to use below load statement

LET vComp = weekday(today());

load

day,

column1

resident table1

where day = $(vComp);

but while reloading it gives an error as "Field not found -- Thu". whereas wheren "day = 'Thu'  " condition is provided, then this load works

I also tried using chr(39) in variable declaration as

LET vComp = chr(39)&weekday(today())&chr(39);

but still not able to use it.

Can anyone provide me a solution for this.

Thanks for help

Aaditya