Hi guys,

I have this statement execute in ibexpert and the result was the one I
expected when all parameters are null. But in IBO this statement fetches
all the records from the table? Is this kind of statement not valid?
Please advise thanks

select *
from customer
where status != 'CAN' and (name containing :null or name starts with :null2)


regards,

james