The LIKE operator in a subquery

From: Melvyn Rosengarden <melrose_at_rochester.rr.com>
Date: Sun, 30 Sep 2001 01:38:04 GMT
Message-ID: <0Iut7.572579$EF2.80628625_at_typhoon.nyroc.rr.com>


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 - 03:38:04 CEST

Original text of this message