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]
