From: Dan Nelson
Date: April 23 2003 9:20pm
Subject: Re: handle nulls
List-Archive: http://lists.mysql.com/mysql/138168
Message-Id: <20030423212036.GH50895@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Apr 23), Sidar Lopez Cruz said:
> can i do this: select isnull(x,0)

No, because isnull only takes one argument.  You probably meant to use

SELECT IFNULL(x,0)

which will replace NULLs with 0 in the result.

-- 
	Dan Nelson
	dnelson@stripped