List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:April 23 2003 9:20pm
Subject:Re: handle nulls
View as plain text  
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
Thread
handle nullsSidar Lopez Cruz23 Apr
  • Re: handle nullsDan Nelson23 Apr