Use of UPPER and LOWER function in SQL server ?

UPPER FUNCTION

UPPER function is used to get the Upper case character of the given character expression

Syntax:

UPPER(CHARACTER EXPRESSION)

Example:

SELECT UPPER('jk sql server blog spot')

Output:

JK SQL SERVER BLOG SPOT

LOWER FUNCTION

LOWER function is used to get the Lower case character of the given character expression

Syntax:

LOWER(CHARACTER EXPRESSION)

Example:

SELECT LOWER('JK SQL SERVER BLOG SPOT')

Output:

jk sql server blog spot