Case using Between with Text

MRasmussen

Hello,

I am trying to use the statement:

CASE WHEN `START_ZONE` BETWEEN 'A' AND 'Z' THEN `PICKUP_TERMINAL` ELSE LEFT(`START_ZONE`,5) END

However, it is not validating for me, what am I missing on this?

MRasmussen

It was giving me an error, but when I closed the calculation it accepted it and returned the desired results.