select case when field3-field4 = 1 then 'a' when field3-field4 = 2 then 'b' when field3-field4 = 3 then 'c' else 'x' end as some_new_field_name from Table where field1=:f1 and field2 = :f2