Subject Re: [ib-support] Using LIKE with a subquery
Author Woody
From: "Stevio" <redeagle@...>
> Has anyone got any ideas for this? Is it possible to have SQL that
> says LIKE WHAT IS IN this subquery.
> e.g. if the subquery returns "foot", I then want SQL to say LIKE '%foot%'.
> The problem is the "foot" would be returned from a subquery.
> If it is not possible please let me know.

I don't think it's possible with a sub-query, however, you can probably
accomplish this in a stored procedure. Use the sub-query as the initial FOR
SELECT query in the procedure and inside of that find matching records and

Woody (TMW)