I have two text columns in a single table containing street addresses which when I compare them on a row by row basis in a query, should sometimes be the same (equal). The test fails repeatedly because as I discovered, the governmental agency that created the table systematically inserted two (not the usual one) blanks between the street number and the street name (in just one of the columns). There may be other instances (for example two blanks between the street name and the street type (Drive, Road, Avenue, etc.) although for the moment, I can't attest to that. Is there some way that I can remove all blanks in both columns? (I presume that all characters in the field which are not valid ASCII characters are "null" characters which would not be affected by this compression.)

Thanks,
Wellen

Find & Replace - find 2 spaces and replace with one space