> -----Original Message----- > select id, lname from godev.user where upper(sepr)='Y' In most databases sepr should not be 'y' (lower case). But if that is possible in your case, then I think "... where sepr in ('Y','y')" is what I would use. It might make difference which character is first in the parenthesis. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------