On Tuesday, September 25, 2001, at 10:30 AM, [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
