Quick query to fix gridsqare case

[emics]

I think I'm a maniac but I really like grids written with only the first two characters in capital letters (ex. JN03gh).
I created this quick query to automatically correct the data on the DB.

UPDATE TABLE_HRD_CONTACTS_V01 SET COL_GRIDSQUARE = CONCAT (UPPER( SUBSTR(COL_GRIDSQUARE, 1,4)), LOWER( SUBSTR(COL_GRIDSQUARE, 5)) ) WHERE LENGTH(COL_GRIDSQUARE) > 4

Make good use of it.