Why not just ... SELECT CASE WHEN readership_often_saturday IN ('One', 'Two', 'Three', 'Four') THEN 'Y' ELSE 'N' END AS reader FROM lee; > > > -- //www.freelists.org/webpage/oracle-l