Need help with case stmt
Need help with case stmt
(OP)
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
RE: Need help with case stmt
CODE
" " AS LOGON,
" " AS EMAIL,
CASE
WHEN prem_term_date IS NOT NULL AND prem_term_date < TODAY-120 THEN "true"
ELSE "false"
END AS NOT_ENABLED
"false" AS LOCKEDOUT
FROM prempmst
WHERE prem_proj = 0
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Need help with case stmt
Thanks PHV, I tried everything but that. This is the first time using case, and it's pretty cool!!!
Can you help me with this one, man, I'm really stumped:
h