Darren DICK
d.dick at uws.edu.au
Sun Dec 5 20:38:13 CST 2004
Hi Guys I'm trying to comparing phone numbers and report dupes. Basically I get a user to enter a phone number - then check if it is already in the dB If it is then I go to the record that already has it. But of course people legitimately put in spaces after area codas and after the prefixes. So it becomes tricky to compare eg 01 1234 5678 is the same number as 0112345678 but a simple dlookup won't catch it So I wanna remove all the spaces so I am comparing at least the same 'number' OR Do any of you have a method for comparing or routing out dupe phone numbers?? Many thanks in advance Darren