case statement based on another column

Question

Dear experts,

based on the below data, Instead of updating data. I want to handle these in case statements.

IF CODE= SMG_TH/N then show type_num=2 instead of 1

Answer 1

Try:

select ROW_ID, CODE, case when CODE = 'SMG_TH/N' and TYPE_NUM = 1 then 2 else TYPE_NUM end as TYPE_NUM
from MyTable