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 :
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