Re: using LIKE with IN

You can use OR:

SELECT table_name,num_rows
FROM user_tables
WHERE table_name LIKE '%NS_%'

   OR table_name LIKE '%NA_%';

--
Have a nice day
Michel

<cjamblues_at_my-deja.com> a écrit dans le message : 87srja$55s$1_at_nnrp1.deja.com...
> 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.
Received on Thu Feb 10 2000 - 02:20:12 CST