change value of column using CASE MSSQL

Can I do something like below with CASE in MSSQL

(Case When location = 'Columbia' Then (direction = 942) Else direction End) as newdirection  

Originally Columbias direction is 941

https://stackoverflow.com/questions/65376972/change-value-of-column-using-case-mssql December 20, 2020 at 12:41PM