şunlara bi bak istersen belki birşey çıkar pek inceleyemedim

http://dev.mysql.com/doc/refman/5.0/...tion_substring
http://dev.mysql.com/doc/refman/5.0/...function_upper