>>>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.
One more thing. The version with macro substitution may be Rushmore optimizable with appropriate index which is very unlikely with EVALUATE().
--sb--