I have a contacts database that, in order to avoid duplicates, keeps email addresses as unique. when I try and create a new contact if it has the same email it will tell me and i can't add them. However if I then do a search by that contacts email address it will not find them, but tells me that I can't add them because they are already in the database. I then find them another way and hey presto they have the same email address that i just searched for. (the addresses are identical ie now additional spaces)
Can anyone help??