SELECT UPPER(firstname) FROM Person
SELECT LOWER(firstname) FROM Person
LCASE или UCASE соответственно.
Пример:
SELECT UCASE(MyColumn) AS Upper, LCASE(MyColumn) AS Lower
FROM MyTable
SQL-СЕРВЕР 2005:
print upper('hello');
print lower('HELLO');