MYSQL stored function - create function (function definition) problem using FORMAT

Question

Hi all,

I keep receiving an error with the following code. I am trying to make a function that will format a field (content=0.0032) into a varchar/percent (content=0.32%). At the moment i'm just trying to get format to work, and it throws up an error

"Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'len);"

The function definition for "Format" is "Format(X,d)" where x is the number and d is the number of decimal places to round too. It then should output a string ###,###,###.## etc.

My code is as follows:

DROP FUNCTION IF EXISTS percent;
DELIMITER $$

CREATE
    /*[DEFINER = { user | CURRENT_USER }]*/
    FUNCTION `auau7859_aba`.`percent`(num DOUBLE, len INT)
    RETURNS VARCHAR(10)
    DETERMINISTIC

    BEGIN
    RETURN FORMAT(num,len);
    END$$

DELIMITER ;

Save me...Luke

Answer 1

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.percent(num DOUBLE, len INT)

i got this error on trying this. i wanted to write a simple create function i am not able to. please help me out