uuid - how to convert uuid to caps?

[Ehsan_3]

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

[cereal]

Have you tried upper()? Example:

select UPPER(CONCAT('CMRC', LPAD(UUID(), 10, '0')));

• http://dev.mysql.com/doc/refman/5.5/en/string-functions.html#function_upper

[Ehsan_3]

Thanks cereal your solution works fine.