Subject | Re: [IBO] PARAMETER WITH '%*%' |
---|---|
Author | Daniel Rail |
Post date | 2004-02-28T12:06:45Z |
Hi,
At February 27, 2004, 22:20, James wrote:
If what you want is to find a customer that contains :name, then why
not use:
... where customer containing :name
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At February 27, 2004, 22:20, James wrote:
> Iam trying to contruct a sql statement in IB_query with a parameterIt wouldn't work, because :name is part of the string '%:name%'.
> named "name" like this
> ... where customer like '%:name%'
> unfortunately this doesn't work. Anybody has an idea about this one?
If what you want is to find a customer that contains :name, then why
not use:
... where customer containing :name
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)