On Thu, 20 Nov 2003 11:23:31 -0600, J. Stephen Wills wrote: >Anyway, what I'm specifically looking for, is a good way to get : > >A list of distinct table_names that have a column named like this, "Insert%" > >I guess along the lines of :
Steve, SELECT DISTINCT sys_table_name + FROM Sys_tables t1 + WHERE sys_table_id IN + (SELECT sys_table_id FROM sys_columns c2 + WHERE c2.sys_column_name LIKE 'Insert%') You STILL haven't updated to single quotes!?!?! Bill
