i use ... SELECT *, UPPER(name) AS testfield FROM testtable ORDER BY testfield hope it helps. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]