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 · Answer

SQL SERVER 2005   print upper  hello    print lower  HELLO

User · Answer

LCASE or UCASE respectively   Example   SELECT UCASE MyColumn  AS Upper  LCASE MyColumn  AS Lower FROM MyTable

User · Answer

LCASE or UCASE respectively   Example   SELECT UCASE MyColumn  AS Upper  LCASE MyColumn  AS Lower FROM MyTable

User · Answer

You can use LOWER function and UPPER function  Like  SELECT LOWER  THIS IS TEST STRING     Result   this is test string   And  SELECT UPPER  this is test string     result   THIS IS TEST STRING

User · Answer

SELECT UPPER firstname  FROM Person  SELECT LOWER firstname  FROM Person

User · Answer

LCASE or UCASE respectively   Example   SELECT UCASE MyColumn  AS Upper  LCASE MyColumn  AS Lower FROM MyTable

User · Answer

LCASE or UCASE respectively   Example   SELECT UCASE MyColumn  AS Upper  LCASE MyColumn  AS Lower FROM MyTable

User · Answer

You can do   SELECT lower FIRST NAME  ABC FROM PERSON   NOTE  ABC is used if you want to change the name of the column

User · Answer

SQL SERVER 2005   print upper  hello    print lower  HELLO

User · Answer

SELECT UPPER firstname  FROM Person  SELECT LOWER firstname  FROM Person

User · Answer

SELECT UPPER firstname  FROM Person  SELECT LOWER firstname  FROM Person

User · Answer

SQL SERVER 2005   print upper  hello    print lower  HELLO

User · Answer

You can do   SELECT lower FIRST NAME  ABC FROM PERSON   NOTE  ABC is used if you want to change the name of the column

User · Answer

SELECT UPPER firstname  FROM Person  SELECT LOWER firstname  FROM Person

User · Answer

SQL SERVER 2005   print upper  hello    print lower  HELLO

User · Answer

You can use LOWER function and UPPER function  Like  SELECT LOWER  THIS IS TEST STRING     Result   this is test string   And  SELECT UPPER  this is test string     result   THIS IS TEST STRING

[sql] SQL changing a value to upper or lower case

Examples related to sql

Examples related to case

Examples related to uppercase

Examples related to lowercase