create function help

[Todd Woolums]

New to mysql functions and looking for some help. Here is what I have but it keeps saying I have a syntax error. Sql statement works as I would expect just can't get the function to work.

CREATE FUNCTION `getApplications`(server_id int(25))
RETURNS varchar(255)
READS SQL DATA
BEGIN

SELECT group_concat(name) INTO applications
FROM application a,application_server_join asj
WHERE a.application_id =asj.application_id and asj.server_id = server_id;
RETURN applications;

END