Comments
Sort by recent activity
Looks like checking "trim trailing spaces" under Edit Project took care of the problem. Still not sure why Table A Char(6) would only show 3 chars for XXX in the column while Table B would show 6 chars for XXX. It is correct to show 6 chars for a Char(6) column. It's almost like Data Compare was seeing some rows in Table A as Varchar(6) because it was correctly showing 90% of the rows correctly. Thanks for your help. Love the compare products!! / comments
Looks like checking "trim trailing spaces" under Edit Project took care of the problem. Still not sure why Table A Char(6) would only show 3 chars for XXX in the column while Table B would show 6 c...