Re: Getting my head around nulls

On Tuesday, September 25, 2001, at 10:30 AM, Ben.Edwards@chase.com wrote:

Thanks for correcting my misspelling, Andrey, "IS NULL" not "IS_NULL". Another thing to look at, Ben, is IFNULL(). I would give you an example,

but

I never got it to work like I thought it should ;) I think it is supposed

to

return an alternate value for NULLs.

Just had a look at manual, ifnull() seems close to useless. However if they had NVL(), as Oracle douse.... NVL( column|litrel, '*null*' ) This takes a column or literal as its first arg and if arg is null returns 2nd arg otherwise returns arg. In other words if the column is null it is replaces by arg2 otherwise it is simply returned.

Um, that's what ifnull() does. At least it works for me. -Steve

Next week I will sing the prases of the oracle decode statement -;) The week after that I will get all exited about MySQL freetext indexes, yum, yum. Neb -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net