I have to compare Address and Add1 using like operator. Thank you - stay tuned. [article3] ( [id] [int] NOT NULL, [type] nchar(10) NULL, [cost] nchar(10) NULL, extra1 int, extra2 int ) In order to compare the columns I will use this query: USE dbtest01 GO SELECT c2.table_name, c2.COLUMN_NAME FROM [INFORMATION_SCHEMA]. Contact.