i used row_number ,but how to get multiple condition in update

for example if condition = 'HF'

then update

else if condition ='AST'

then update