From: "Stevio" <redeagle@...>

> Has anyone got any ideas for this? Is it possible to have SQL that

basically

> 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
use SUSPEND.

Woody (TMW)