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