Re: How to include an IF() statement in SQL?

select name
  from customers
 where custid exists (select parentid

                       from customers)

Bob Cunningham (bcunn_at_oanet.com) wrote:
: On Tue, 01 Sep 1998 17:30:40 -0700, Troy Perchotte <max_at_headroom.com>
: wrote:
 

: >How do I include a condition within a select statement?
: >Something like the following (only one that works):
: >
: >select if(customers.custid=customers.parentid,'',customers.name) as
: >parent_name from customers;
: >
: >Troy Perchotte
: >
: >
 

: You can use the DECODE function. E.g.:
 

: SELECT DECODE(custid,parentid,NULL,name) parent_name FROM customers;

: Bob Cunningham
: bcunn_at_oanet.com

--
While DSC may claim ownership of all my ideas (on or off the job),
DSC does not claim any responsibility for them. Warranty expired when you
opened this article and I will not be responsible for its contents or use.