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>
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
Select column2 from Table-B where
where Column1 LIKE =(
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