I am trying to query mailing address records that match physical address records, but the two fields sometimes have data in a different format. For example, the property's mailing address may be shown as '123 NW Elm Street', while the physical address may be shown as '123 Elm St'. Even if I can just query whether the address contains the same street name that would help me if I knew if 'Elm' was anywhere in the address. There is a field with just street name, with no number or prefix or suffix.
I am trying to do a definition query to select nearly matching records with wildcards with something like this:
"StreetAddress" LIKE "%StreetName%"
I have tried numerous variations with no luck, including '%'+"STreetName"+'%' etc.
Is there a "FIELD_A" INCLUDES "FIELD_B" query or a "FIELD_A" CONTAINS "FIELD_B" command?