The ibec_Decode function has the functionality of an IF…THEN…ELSE statement.
function ibec_Decode(Expression : variant; Search : variant; Result : variant; [Search : variant; Result : variant]... [; Default : variant]) : variant;
execute IBEBlock (CityCode integer) returns (CityName varchar(100)) as begin CityName = ibec_Decode(:CityCode, 1, 'Berlin', 2, 'Rome', 3, 'Bangkok', 'Unknown'); suspend; end