[sql]
SELECT (CASE
WHEN column is null THEN 1
WHEN trim(column) = '' THEN 2
ELSE 3
END) as column_alias FROM table;
[/sql]