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