> You can do: > > > SELECT last_name, first_name, phone, if(pub_email="Y",email,"") as email > FROM `mydatabasetable` WHERE `current_member` = "Y" AND `pub_name` = "Y" > ORDER BY last_name ASC >
Gracias, Carlos. This worked fine! ---Fritz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql