/***** UpdateModalitiesInStudy StoreProc ****/ DROP PROCEDURE IF EXISTS UpdateModalitiesInStudy; CREATE PROCEDURE UpdateModalitiesInStudy ( IN instudyid bigint, IN d00080060 varchar(255) ) BEGIN DECLARE studymodality VARCHAR(255); DECLARE isModPresent boolean; SET isModPresent = FALSE; SET studymodality = NULL; SELECT Study.d00080061 INTO studymodality FROM Study WHERE Study.studyid = instudyid; IF studymodality IS NULL THEN UPDATE Study SET Study.d00080061 = d00080060 WHERE Study.studyid = instudyid; ELSE SET isModPresent = (SELECT LOCATE(d00080060, (SELECT Study.d00080061 from Study where Study.studyid = instudyid),1)); IF ( isModPresent = 0 ) THEN UPDATE Study SET Study.d00080061 = (SELECT CONCAT(studymodality , "/" , d00080060 )) where Study.studyid = instudyid; END IF; END IF; END