Change the comparison between the data

MarikaAMarikaA Posts: 2
edited September 30, 2015 8:20AM in SQL Data Compare 11
Good morning,
I have two tables: Person and Person1. These have only one column: "id". The data are respective: "Person@Mario", "Person@Sammy", etc into the first table, and "Person1@Mario", "Person1@Sammy", etc into the second table. Now I need to compare these tables, and I want that the result is equals, because I want that the substring "Person@" and "Person1@" are not included into the comparison.

There is a solution?
Sign In or Register to comment.