DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `col1` varchar(200) default NULL,
  `col2` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `test` WRITE;
INSERT INTO `test` VALUES ('Sveta',2);
UNLOCK TABLES;

DELIMITER |;
DROP FUNCTION IF EXISTS `proc` |
CREATE FUNCTION `proc`(parm VARCHAR(20)) RETURNS text CHARSET latin1
BEGIN
  DECLARE v VARCHAR(100) DEFAULT 'Hello';
  SELECT CONCAT(v, ', ', parm, '!') INTO v;
  RETURN v;
END |
DELIMITER ;|

SELECT 
    (SELECT proc(col1)) as greet,
    (SELECT proc(col1) as greet)
FROM test;


SELECT 
    (SELECT count(col1)) as greet,
    (SELECT count(col1) as greet)
FROM test;