How to include an IF() statement in SQL?

[Quoted] [Quoted] How do I include a condition within a select statement? [Quoted] [Quoted] Something like the following (only one that works):

select if(customers.custid=customers.parentid,'',customers.name) as parent_name from customers;

Troy Perchotte Received on Tue Sep 01 1998 - 00:00:00 CEST