Thanks Woody. However, I'm not familiar with SUSPEND. How does it work?

Stephen

----- Original Message -----
From: "Woody" <woody.tmw@...>

> 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)