I use the following code to generate a uuid concat with CMRC
it works fine uuid is generated in lower case i.e. CMRC+someString in lower case

I could not find anything to resolve this i had to post this on here for help
how can I convert this generated uuid to caps or uppercase within trigger in mysql before insert?

BEGIN
INSERT INTO clients_seq VALUES (NULL);
SET NEW.cid = CONCAT('CMRC', LPAD(UUID(), 10, '0'));
END

Thanks cereal your solution works fine.