Re: Irritating problem
From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Mon, 7 Nov 2011 15:50:11 -0800
Message-ID: <CACpWLjOfEuXuZH6oMa0hcge+QYUHTYUZ8oO+kyN+LKku=qPwWg_at_mail.gmail.com>
Why not just ...
SELECT CASE
WHEN readership_often_saturday IN ('One', 'Two', 'Three', 'Four') THEN 'Y'
FROM lee;
Date: Mon, 7 Nov 2011 15:50:11 -0800
Message-ID: <CACpWLjOfEuXuZH6oMa0hcge+QYUHTYUZ8oO+kyN+LKku=qPwWg_at_mail.gmail.com>
Why not just ...
SELECT CASE
WHEN readership_often_saturday IN ('One', 'Two', 'Three', 'Four') THEN 'Y'
ELSE 'N' END AS reader
FROM lee;
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 07 2011 - 17:50:11 CST