On 25 Jun 2002 at 21:02, Stevio wrote:

>basically says LIKE WHAT IS IN this subquery.
>
>e.g. if the subquery returns "foot", I then want SQL to say LIKE
>'%foot%'.

Have you ever tried "Some_field LIKE (SELECT Other_field||'%' FROM
Table WHERE 'a conditional is satisfied')"?
The only problem is: subquery has to be a singleton-select i.e.
return only one record.

SY, Dimitry Sibiryakov.