SQL conditional query

So the following code doesn't work in Access SQL:



select ename, sal

case when sal <= 2000 then 'UNDERPAID'

when sal >= 4000 then 'OVERPAID'

else 'OK'

end

from emp



I'm wondering how to do this query in Access. This comes from the book "SQL Cookbook" by Molinaro.

SQL conditional query