My database has duplicates because when I loaded the excel spreadsheet using get external data some phone numbers were (111)111-1111, and some were (111) 111-1111 so that nasty space after the right parenthesis causes my querry not to see a duplicate. There are 88,000 records in my database. Is there any way I can remove the space?
thank you
George