Hi, I am trying to return the customers that are unique in my table using this query
SELECT distinct custnum, billFname, BillLName, BillPhone, BillZip FROM Mytable
I am getting 40 additional records when I run this query, than when I run
SELECT COUNT DISTINCT(custnum) FROM Mytable
Upon further investigation I have found this is because it is treating the fields where the are slight differences, eg zipcode ad65ty and ad6 5ty as unique records (thus the customer appears twice in the returned results), any ideas on how I could structure my query to return records on distinct custnum only? (ignoring the rest of the fields eg zipcode, BillLname in the distinct part) so where there are differences like the one highlighted above the customer is only returned once!