we have Table1, Table2 with similar structure and data.
we do a SELECT from both tables and store it in 2 Excel sheets.
when we try to compare data using =EXACT(Table1cell1, Table2cell1)
or =(Table1cell1=Table2cell1), the comparison returns false, even for the rows looking identical..
select * from Table1
select * from Table2
Though the result set of both the queries seems to be identical, when we keep these results in excelsheet and do an EXACT or = comparison, it returns FALSE
Will there be any characterset/space related issues in Sybase..?
If so how to verify and troubeshoot this problem.?