I have two IDs that are the same when comparing the 15 character version of each other (the only difference is capitalization). When I attempt to query the data for ID #1 I am receiving the data from ID #2. I tried querying the 18 character version of ID#1 but nothing gets returned? Has anyone ever encountered this issue before?
ID#1 = a1e1E000002KVhJQAW ID#2 = a1e1E000002KVhjQAG
for example by query is: SELECT Name FROM Contact WHERE ActiveDUId__c='a1e1E000002KVhJQAW' and nothing is returned