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')

Click here to go on website