Oracle nvl function equivalent.

2004-01-04 Thread Arun Natarajan 
Hello All,
Is there an equivalent to the nvl() function of Oracle available in MySql. I
am currently using version 4.1 alpha and am trying to execute the following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;

Also, I tried to create a user defined function as below, but it failed.
Could some one help me out here?

Create Function nvl(fieldVal INTEGER(10)) RETURNS INTEGER(10)
BEGIN
If fieldVal==null Then
return 1;
else
return fieldVal;
END

Regards,
Arun N


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Oracle nvl function equivalent.

2004-01-04 Thread robert_rowe 

What does nvl do? Here is a list of the functions from the MySQL manual:

http://www.mysql.com/doc/en/Function_Index.html

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Oracle nvl function equivalent.

2004-01-04 Thread Ed Leafe 
On Jan 4, 2004, at 7:09 PM, Arun Natarajan wrote:

Is there an equivalent to the nvl() function of Oracle available in 
MySql. I
am currently using version 4.1 alpha and am trying to execute the 
following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
	In MySQL, the function is called IFNULL().

 ___/
/
   __/
  /
 /
 Ed Leafe
Linux Love:
unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]