Archives of the TeradataForum

Message Posted: Tue, 23 Aug 2005 @ 11:19:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

To whom it may concern ...

Try this:-

     Select * from
     DBC.TABLES
     WHERE DatabaseName (NOT CS) = 'TEST1' (NOT CS)
     AND TABLENAME (NOT CS) IN

     ANY

     ('T1', 'T2');

_______________________
Dave Clough
Database Designer
Express ICS

	<Prev	Next>		<<First	<Prev	Next>	Last>>