Need help with case stmt 1

ejaggers · Dec 3, 2009

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 · Dec 3, 2009

What about this?

Code:

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 · Dec 3, 2009

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Need help with case stmt 1

ejaggers

Programmer

PHV

MIS

ejaggers

Programmer

Similar threads

Part and Inventory Search

Sponsor