Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 

Working with LOWER () and UPPER () function in SQL Server 2008 using PL/SQL.

Author: Shehzad Hemani

In this simple article you will learn that how to work with LOWER () and UPPER () function in SQL Server using PL/SQL.

 It is also a very simple commonly used function of SQL Server. It is used to change the case of the given string. It takes the string as an input parameter. 

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 
 

   
Add Article Comment:
Name :
Email Address :
   
Comments :
 
   
<< Working with DATENAME () function in SQL Server 2008 using PL/SQL.

Disclaimer - Privacy
© 2002-2017 DevASP.net