how to update column value in sqlserever

Question

hi friends please help me :

 

 

i want to update my product price

 

 

Select a.Category_Name, b.Price,c.Qty,b.Price_Updated_by,

case when b.Price_Updated_by = 'Product' then b.Price*c.Qty

else a.cat_price*c.Qty end as[TotalPrice],

 

i want i check

 case when a.Category_Name='Bedsheet Tapestry' then  b.Price='60',

 

 i want b.price =60 when category name Bedsheet Tapestry

 

what it is possible please help