Lower - Returns a character expression after converting uppercase character data to lowercase
For Eg.
Select CompanyName,
Lower(CompanyName) As LoweCase,
Upper(CompanyName) As UpperCase,
From Customers
Result
In Built Function in T-SQL - Upper and Lower
Upper - Returns a character expression with lowercase character data converted to uppercase.
Lower - Returns a character expression after converting uppercase character data to lowercase
For Eg.
Select CompanyName,
Lower(CompanyName) As LoweCase,
Upper(CompanyName) As UpperCase,
From Customers
Result
Lower - Returns a character expression after converting uppercase character data to lowercase
For Eg.
Select CompanyName,
Lower(CompanyName) As LoweCase,
Upper(CompanyName) As UpperCase,
From Customers
Result
