>>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().

In my test, EVALUATE() executed 6 times for 2 records.