Page 2 - Conversion in an INSERT query

DROP FUNCTION IF EXISTS uc_words;

DELIMITER ||
CREATE FUNCTION uc_words(lastName TEXT)
	RETURNS TEXT
	NO SQL
	DETERMINISTIC
	COMMENT 'Title Case. Assumes that there arent numbers or weird chars'
BEGIN
	-- loop counter
	-- (change type if you expect input longer than 255 chars)
	DECLARE i TINYINT UNSIGNED DEFAULT 1;
	-- limit for i
	DECLARE maxlen TINYINT UNSIGNED DEFAULT LENGTH(lastName) + 1;
	-- current char
	DECLARE ch CHAR(1) DEFAULT '';
	-- output buffer
	DECLARE str_out TEXT DEFAULT '';
	-- a word is already started?
	DECLARE in_word BOOL DEFAULT FALSE;
	
	-- loop chars
	WHILE i < maxlen DO
		-- get current char
		SET ch = SUBSTRING(str_in FROM i FOR 1);
		
		IF ch REGEXP '[[:alpha:]]' THEN
			-- letter
			IF in_word IS TRUE THEN
				-- word already started
				SET str_out = CONCAT(str_out, LOWER(ch));
			ELSE
				-- word starts here
				SET str_out = CONCAT(str_out, UPPER(ch));
				SET in_word = TRUE;
			END IF;
		ELSE
			-- no letter; add it and remember we're out of word
			SET str_out = CONCAT(str_out, IF(ch, ch, ' '));
			SET in_word = FALSE;
		END IF;
		
		SET i = i + 1;
	END WHILE;
	
	RETURN str_out;
END;
||
DELIMITER ;