The LIKE operator in a subquery

Thread View: bit.listserv.sqlinfo

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Melvyn Rosengarden Sun, 30 Sep 2001 01:38

#298

Author: Melvyn Rosengarden
Date: Sun, 30 Sep 2001 01:38

18 lines
1613 bytes

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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads