I'm working on an inventory list that seems to have duplicate values in the SNs because a dash (-) was entered in the string on some records, not on others. What function do I use to remove the dash in a query to view duplicates? Most records in question are in the format of 00-0000, but some are longer, 0000-00000. Thanks for any help provided!!