The PROPER() function changes the first letter to upper case, and
leaves the rest as lower case. Try using UPPER(text) and see if that
works. If it doesn't, please post back with examples so we can
troubleshoot with you.