[digioz]

The following syntax works fine for me:

Code:

SELECT UCASE(columnName) FROM `table_name`

Is that how you used it? Another option would be to convert string to upper case using the PHP built-in "strtoupper()" function. Here is more on that:

http://us3.php.net/strtoupper