CREATE OR REPLACE   PROCEDURE  sp_test() 
    BEGIN
        SET @z = ‘hello World‘;
            SELECT @z ;
    END;

DELIMITER $$

DROP FUNCTION IF EXISTS `GetUserName`$$

CREATE FUNCTION `GetUserName`(nUserID INT)
    RETURNS VARCHAR(64)
BEGIN
    DECLARE sUserName VARCHAR(64);
    SELECT FirstName INTO sUserName FROM Users WHERE Seq = nUserID;
    RETURN sUserName;
END$$

DELIMITER ;