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?
INSERT INTO clients_seq VALUES (NULL);
SET NEW.cid = CONCAT('CMRC', LPAD(UUID(), 10, '0'));