Need help with case stmt 1

[ejaggers]

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

 

[PHV]

What about this?

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 AS NOT_ENABLED
        "false" AS LOCKEDOUT
  FROM prempmst
  WHERE  prem_proj = 0

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ejaggers]

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:

http://www.tek-tips.com/viewthread.cfm?qid=1581452&page=1