You're a genius - that works!!!!! -----Original Message----- From: Bastien Koert [mailto:phpster@xxxxxxxxx] Sent: Wednesday, August 26, 2009 2:02 PM To: Andrew Ballard Cc: Shawn McKenzie; php-general@xxxxxxxxxxxxx; David Stoltz Subject: Re: Re: How to output a NULL field? One option then, might be to format the result with SQL using a CASE WHEN THEN statement or ISNULL / IFNULL to set it to empty string -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php