I’m trying to find some records based on property address. The property address string contains the numeric street number as well as street name. I’ve got it set to check within the exact state/city/zip combo and soundex(prop_address) must match, but its returning WAY too many results for my liking, apparently everything sounds the same? Does anyone have any input on this function I may find useful?
edit:
heres what I was running, with real data though of course
where
soundex(TRIM(REGEXP_REPLACE(UPPER(P.PROPERTY_STREET_ADDRESS), '( ){2,}', ' ' )))||'-'||p.city_name||'-'||p.property_alpha_state_code||' '||p.property_zip_code in (
soundex('1234 STREET NAME')||'-CITYNAME-OH xxxxx',