How to Work with LOWER () and UPPER () function in SQL Server 2008 using PL/SQL?

Answer 1

Upper () Syntax:

UPPER ('String')  

Example:

SELECT

UPPER('this is Lower TEXT')

AS

ResultingString 

Output:

Resulting String

---

THIS IS LOWER TEXT

Lower () Syntax:

LOWER ('String')  

Example:

SELECT

Lower('this is Lower TEXT')

AS

ResultingString 

Output:

Resulting String

---

this is lower text