SQL changes the value to upper or lower case

Question

How to make a field in select sql expression in upper or lower case?

Example:

choose a name from Person

How to make firstname always return uppercase and also always return lowercase letters?

Answer 1

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

Answer 2

LCASE or UCASE respectively.

Example:

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

Answer 3

SQL SERVER 2005:

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

Answer 4

You can use LOWER function and UPPER function . how

 SELECT LOWER('THIS IS TEST STRING') 

Result:

 this is test string 

and

 SELECT UPPER('this is test string') 

result:

 this is test string 

Answer 5

You can do:

 SELECT lower(FIRST NAME) ABC FROM PERSON 

NOTE. ABC used if you want to change the column name