Click here to hide categories Click here to show left categories

User: Home          welcome : Guest          Log In / Register here     




Case change in sql server

If you want to change the case of  content in table in sqlserver or in some condition where needs to compare items then you may need to change the case of content. if you want to change in UPPER case then write

print Upper('india')

It wil show INDIA

Condition may be like this

select * from tbl_product where productname=Upper('Oven')

if you want to change in Lower case then write

print Lower('INDIA')

It will show india

Condition may be like this

select * from tbl_product where productname=Lower('Oven')
Share this article   |    Print    |    Article read by 3053 times
Author:
Rohit kakria
I am software developer
Related Articles:
Related Interview Questions: