How do you label the column using a case stmt? I want the prem_term_date case labe to be "DISABLED", but AS "DISABLED", gives me an error.
SELECT prem_fname || " " || prem_lname AS NAME,
" " AS LOGON,
" " AS EMAIL,
CASE
WHEN prem_term_date IS NOT NULL AND prem_term_date < TODAY-120
THEN "true"
ELSE "false"
END,
"false" AS LOCKEDOUT
FROM prempmst
WHERE prem_proj = 0
SELECT prem_fname || " " || prem_lname AS NAME,
" " AS LOGON,
" " AS EMAIL,
CASE
WHEN prem_term_date IS NOT NULL AND prem_term_date < TODAY-120
THEN "true"
ELSE "false"
END,
"false" AS LOCKEDOUT
FROM prempmst
WHERE prem_proj = 0