>>I think someone told me to avoid macro, so i asked the alternate ?
>
>
>To validate and for a speed comparison, create the three SQL expressions explicitly (matching the logic inside the CASE statement) and run each repeatedly to get into the measurable range. Compare those explicit tests to the macro tests. You'll see if there are any issues of performance when using a macro in this case.
I agree and I think for that particular case since macro is evaluated only once, there will be very small performance gain which may be not visible.
If it's not broken, fix it until it is.
My Blog