This is a continuation of my previous post. LINK: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Architecture-Design/Q_25022091.html
I needed to compare two tables, one table containing the ID in binary format, and one table containing the same ID in varchar.
I closed my earlier post, because eval(id) seemed to take care of this issue, but I realized after that it only worked on a small set that I was testing.
The issue is:
say the id in question is: 0x00001900004F6E38
when i do say: tablea.id = eval(tableb.id)
all table A ids that had 0x00001900004F and any 4 other chars showed up as being the same.
meaning 0x00001900004F1111 showed as being equal to 0x00001900004F6E38, as well as 0x00001900004F9999, etc...
Does anybody know any way around this?? Thanks.