Home » SQL & PL/SQL » SQL & PL/SQL » LIKE and 2 SELECTS...
LIKE and 2 SELECTS... [message #23452] Tue, 10 December 2002 13:32 Go to next message
DP
Messages: 15
Registered: February 2002
Junior Member
I am trying to match names that start with the names from the inner table.

How do I do this?

select NAME from myTbl where NAME like
(select TRACK_NAME from myInnerTbl where TRACKING_NUM = 800) +'%'

I want it to do output like
select NAME from myTbl where NAME like 'TheName%'

Report message to a moderator

Re: LIKE and 2 SELECTS... [message #23453 is a reply to message #23452] Tue, 10 December 2002 14:10 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
 
select t.name
  from myTbl t, myInnerTbl it
 where it.tracking_num = 800
   and t.name like it.track_name || '%';

Report message to a moderator

Previous Topic: Encountered the ADODB.Command error
Next Topic: in , out parameter problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 12:49:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.