select * from branch
Case 1 when '101' then '!' Else 1 End
This works in informix 9.4 and greater and MSSQL but not informix 9.3, anyone know why or have a solution for 9.3?
move your case to one of the columns and then call it by reference
select case...., *
order by 1