Case When 'COLUMN_1' = 7777 Then regexp_replace(input_string, regex, replacement)
End

Case When 'COLUMN_1' = 7777 Then regexp_replace(“COLUMN_2”, right(contents of the field ,2), 99)
End