On Thu, Aug 27, 2009 at 9:37 AM, David Stoltz <Dstoltz@xxxxxxx> wrote: > 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 > > Let me do this simple question... is your Sql Server legal? Then use it. If not, why don't you migrate to an open source alternative? there are a lot of DB you can use, and if you use an open source alternative then it's legal, that's mean you, or your client, do not have to pay for use it. I'm not going to say *that* DB is better that *this* other, this is a matter of taste. -- Martin Scotta
