Subject | Re: [IBO] PARAMETER WITH '%*%' |
---|---|
Author | James |
Post date | 2004-02-28T16:32:42Z |
Hi
Daniel Rail wrote:
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
Daniel Rail wrote:
> Hi,Thanks Daniel. I didn't even know there is such as containing in
>
> 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
>
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