Subject Re: [IBO] PARAMETER WITH '%*%'
Author James
Hi

Daniel Rail wrote:

> Hi,
>
> At February 27, 2004, 22:20, James wrote:
>
> > Iam trying to contruct a sql statement in IB_query with a parameter
> > named "name" like this
>
> > ... where customer like '%:name%'
>
> > unfortunately this doesn't work. Anybody has an idea about this one?
>
> It wouldn't work, because :name is part of the string '%:name%'.
>
> If what you want is to find a customer that contains :name, then why
> not use:
> ... where customer containing :name
>
Thanks Daniel. I didn't even know there is such as containing in
firebird. Is this available only in FB 1.5 or it is already exist since
IB 6? Does this uses the index?

Thanks.



Regards
James