top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
370 views
How to Work with LOWER () and UPPER () function in SQL Server 2008 using PL/SQL?
posted Mar 12, 2016 by Sathaybama

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Mar 12, 2016 by Shivaranjini
...