-- "Reidy, Ron" <[EMAIL PROTECTED]>
The data dictionary is your friend ... SELECT 'x' FROM all_tables WHERE table_name = UPPER(:name);
Depending on access you might be better off selecting from user_tables: less likely to fail and the table name is more likely to be useful in the current user's context (i.e., fewer false hits). -- Steven Lembark 85-09 90th Street Workhorse Computing Woodhaven, NY 11421 [EMAIL PROTECTED] 1 888 359 3508
