Reg. 'drop table' statement

I want to drop the table where table names ends with 'TESTTABLE'. I tried with this:
drop table (select tname where tname like '%TESTTABLE');

But, it does not work.

Please help me to fix it.

Thanks! Received on Mon Aug 18 2003 - 07:16:03 CDT