[Rattlecage Demon]

Need to convert lower case characters to uppercase characters with MySQL. Tried UCASE(columname) but returns error. Any suggestions??

[digioz]

The following syntax works fine for me:

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

[NeverMind]

Originally Posted by Rattlecage Demon

Need to convert lower case characters to uppercase characters with MySQL. Tried UCASE(columname) but returns error. Any suggestions??

probably you had a syntax error somewhere else in the query.. or maybe your MySQL version doesn't have this function?!
try using UPPER() instead