using LIKE with IN

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 Wed Feb 09 2000 - 17:01:02 CST