CastFox Tech Blog

DELIMITER $$ DROP FUNCTION IF EXISTS FNC_CODE_NAME; CREATE FUNCTION FNC_CODE_NAME(code VARCHAR(32)) RETURNS VARCHAR(32) BEGIN DECLARE returnVal VARCHAR(32); SELECT CDT_CODENAME INTO returnVal FROM PRG_CODE WHERE CDT_CD = code; RETURN returnVal; END $$ DELIMITER ;