>>Rather than Macro substitute your variable, you might prefer to use the EVALUATE function.
>
>That's the case when macro substitution is more efficient because it's evaluated only once when statement is executed not for every row as EVALUATE().

I stand corrected.