I know .... its strange .... but it does happen sometimes. The O'reilly book "Mastering Oracle SQL" by Mishra and Beaulieu has information on the Case command. -----Original Message----- From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx] Sent: Monday, July 19, 2004 5:16 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: how to write this sql? Wow.....Mladen was being serious? ;-) Here, check this out: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/expr essions5a.htm Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Post Hoc Ergo Propter Hoc" -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mladen Gogala Sent: Monday, July 19, 2004 5:32 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: how to write this sql? On 07/19/2004 05:19:26 PM, "Khedr, Waleed" wrote: > You can't be serious! Well, I've been using decode for that purpose and I used CASE in PL/SQL, but this little detail was elusive. I kept combing PL/SQL manual for a CASE expression example. --=20 Mladen Gogala Oracle DBA ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------