At MS Access, Compare two fields

I have two linked table, one from Sybase, the other one from SQL Server 2008. I am comparing the two tables and hope they are the same. One field, in Sybase datatype is text, SQL server is Varchar, how can I compare it? I queried it, it is always showed me they are not the same even in English they are the same.

Who is Participating?
ButlerTechnologyConnect With a Mentor Commented:
I am not sure if this will work or not -- but try using the Trim function (Rtrim and LTRIM).  It is possible that there is extra-white spaces at the end of one of the fields.

HopeQAuthor Commented:
No, it doesn't work. Thanks.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.