Hi Helen

Helen Borrie wrote:

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

The value being pass is from a editbox.text which is null.


james