CREATE FUNCTION SAMPLE_FUNC( param1 VARCHAR(100)) RETURNS INT(11)
READS SQL DATA
BEGIN
    DECLARE id_val INT(11);
        SELECT id INTO id_val FROM t1 WHERE p = param1;
    RETURN(id_val);                                                                                  
END