At 01:43 PM 2/06/2004 +0800, you wrote:

>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)

>name containing :null or name starts with :null2

What is being passed in these parameters?

Helen