I have verified thre should be matches between the two columns in the attached screenshot. However the Data Compare function is not finding matches. Is it due the the different data types being used? Is there a way to override this and just compare the contents? Thanks, Jason [data compare.gif]

Data Compare - not working as desired

ruitorgeir_203 June 17, 2011, 9:02am 21

That works.

Thanks,
Tor

Topic		Replies	Views
Data Compare - No Columns to compare in Wizard Toad Data Point & Toad Intelligence Central	1	828	February 23, 2012
Data Comparison tool inaccurate? Toad for SQL Server	0	815	August 28, 2014
How to compare two different size and type columns Toad Data Point & Toad Intelligence Central	5	1111	July 21, 2011
Data compare between two databases using Data Point Toad Data Point & Toad Intelligence Central	17	4455	August 7, 2018
Issue with Data Compare with UNIQUE Comparison Keys Toad Data Point & Toad Intelligence Central	5	1114	September 24, 2021