From: cl
Date: February 6 2013 4:30pm
Subject: =?utf-8?B?UkU6IFNFTEVDVCBzdWJxdWVyeSBwcm9ibGVt?=
List-Archive: http://lists.mysql.com/mysql/228937
Message-Id: <20130206163044.26753.qmail@s464.sureserver.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

>  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