Firebird 条件函数

1、iif  IIF (<condition>, ResultT, ResultF) 

示例：

select iif( sex = 'M', 'Sir', 'Madam' ) from Customers

2、nullif  NULLIF (<exp1>, <exp2>) 

示例：

select avg( nullif(Weight, -1) ) from FatPeople