SQL Server How to use UPPER & LOWER function

Leave a Comment
        Here I explain use of UPPER & LOWER function.This function is use to convert value of column to uppercase & lowercase.
For explanation I consider a table with following records :
Following statement shown you to convert "CustomerName" column to uppercase :
 We produce folowing result :
Following statement shown you to convert "CustomerName" column to lowerercase :
We produce folowing result :

0 comments:

Post a Comment