Subject Re: [IBO] PARAMETER WITH '%*%'
Author Daniel Rail
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

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)