I am trying to return multiple values from a Function, not sure if it is allowed: delimiter | create function cf_test() returns integer, varchar(255) /* tried with semicolon after varchar(255) */ begin declare p_col2 smallint; declare p_col3 varchar(255); select col2, col3 into p_col2, p_col3 from test where col1 = 1; return p_col1, p_col2; end | and i get the following error when i am trying to create this function: source test5.sql 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 ' varchar(255); begin declare p_col2 smallint; declare p_col3 varch' at line 2 Any advice would be greatly appreciated. Thanks Dinesh