Re: using LIKE with IN

If its only 2 searches you want

SELECT table_name,num_rows
FROM user_tables
WHERE table_name LIKE '%NS_'
OR table_name LIKE '%NA_%';

Dunno any other methods yet ;-(

M

In article <87srja$55s$1_at_nnrp1.deja.com>, cjamblues_at_my-deja.com wrote:
>Greetings --
>How can I combine LIKE and IN in the same sql statement:
>
>SELECT table_name,num_rows
>FROM user_tables
>WHERE table_name IN (LIKE('%NS_%",'%NA_%');
>
>Thanks,
>
>David J Jackson
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
>
>

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!