How can I match for phonenumber in my whereclause?
SELECT id, Membership_number__c, Phone, Email FROM Contact WHERE Phone = :phoneNumberString
Above mathces fine on these phonenumber values: +4550516254
But not this one:
Any ideas? Just to clarify, the query doesn't return the same record for the three "matching" cases, but it can actually return a record. The latter one, can't.