SQL changing a value to upper or lower case

sql case uppercase lowercase

SELECT UPPER(firstname) FROM PersonSELECT LOWER(firstname) FROM Person

sql case uppercase lowercase

LCASE or UCASE respectively.

Example:

SELECT UCASE(MyColumn) AS Upper, LCASE(MyColumn) AS LowerFROM MyTable

sql case uppercase lowercase

SQL SERVER 2005:

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

CodeHunter