ODBC > Convert all Characters in the Specified String to Uppercase/Lowercase

The following are sample SQL statements that convert characters to either uppercase or lowercase. Note that if there are characters in the string that are not letters, they are unaffected by this function.

SELECT lower(name) AS lowername FROM customers WHERE rownum <10
 
SELECT upper(name) AS uppername FROM customers WHERE rownum <10