SQL changing a value to upper or lower case

Question

How do you make a field in a sql select statement all upper or lower case?

Example:

select firstname from Person

How do I make firstname always return upper case and likewise always return lower case?

user_1980 · Answer

SELECT UPPER(firstname) FROM Person

SELECT LOWER(firstname) FROM Person

Stephen_Wrighton_7516 · Answer

LCASE or UCASE respectively.

Example:

SELECT UCASE(MyColumn) AS Upper, LCASE(MyColumn) AS Lower
FROM MyTable

Cirieno_17615 · Answer

SQL SERVER 2005:

print upper('hello');
print lower('HELLO');