Re: The LIKE operator in a subquery

> > Can the LIKE operator be used with anything OTHER than a quoted literal
> > string ?

Yes

> > Select * from Table-A
> > where Column1 LIKE =(
> > Select column2 from Table-B where
> > key = 123 ) || %

This will almost work. However you have to make the last fragment '%' instead of %.

Melvyn Rosengarden wrote:
>
> Can the LIKE operator be used with anything OTHER than a quoted literal
> string ?
> I want a subquery to return a column value (expression) I can use as part of
> a LIKE statement in the outer query. For example
>
> Select * from Table-A
> where Column1 LIKE =(
> Select column2 from Table-B where
> key = 123 ) || %
>
> Can someone please tell me if this possible to do and if so HOW ???
>
> --
> Never be afraid to try something new.
> Remember that amateurs built the ark.
> Professionals built the Titanic.
Received on Sun Sep 30 2001 - 21:35:19 CEST