Upper case display

[illushinz]

I have fields in a database where some of the data is lower, some is upper, i want to display all of it on the webpage in upper case....

I'm sure this is any easy one, i was just having trouble finding it in the manual. Thanks for the help.

[hand]

UPPER(str) Returns the string str with all characters changed to uppercase according to the current character set mapping (the default is ISO-8859-1 Latin1):

mysql> select UCASE('Hej');
-> 'HEJ'
mysql> select UCASE(field) FROM table;
-> 'ABCDEFGHIJ'