can you please past some sample code that i can follow ? i am not an SQL expert like you guys

Thanks Guys !!!! It works, however there is one more condition... some of the tables that begin with CMS_ do not have the column ItemCreatedWhen in them.. can i add...

I have a column called InsertedItemWhen on all tables that begin with CMS_

I want to go though all the tables that being with CMS_ and look for data entered...

how can use to find records after a certain date/time if knew the column name...

Thanks