Is there a wildcard I can use in Find and Replace so that I can get rid of things like 'BLDG 7', or 'UNIT A' from the end of addresses. I am trying to match addresses to an address file that does not include the Unit numbers of BLDG numbers. Is there a way to eliminate these types of details from the end of this text string? I can find them with Select by Attributes where (MyTableName) LIKE '% BLDG %' brings back the records, but in the table I am working on this brings back 1752 records and that
