Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    14

    Unanswered: Though 2 table values seems to be identical, excel EXACT or = comparision gives FALSE

    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..

    Eg

    select * from Table1
    ID Description
    1 Summary
    2 Specification

    select * from Table2
    ID Description
    1 Summary
    2 Specification

    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.?
    Vikram RM

  2. #2
    Join Date
    Jun 2010
    Posts
    51
    Why don't you paste the exact results from table 1 and 2 here. So that we can paste it to excel and try to replicate the issue. It count be due to column data type. May be one char and other is varchar...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •