T
titlepusher
I have 2 tables. Both contain a Name field. I need to check [Name1] against
[Name2] and variants of [Name2]. example: if [Name1] is "Old SPG Land
Co." and [Name2] is "SPG Land associates" OR "Old SPG Real Estate" OR
"LandCo1 & SPG Trust" I want a query to match [Name1] and [Name2] even
though they are not perfect.. or really even close.. just a match on a
"common pattern contained, or closeness or similarity or dirivitive of".
My purpose is to check all new business names we see for upcoming
transactions against a list of known fraudulant names. The scammers seem to
use variations of a few company names over and over.. Thank you, tp
[Name2] and variants of [Name2]. example: if [Name1] is "Old SPG Land
Co." and [Name2] is "SPG Land associates" OR "Old SPG Real Estate" OR
"LandCo1 & SPG Trust" I want a query to match [Name1] and [Name2] even
though they are not perfect.. or really even close.. just a match on a
"common pattern contained, or closeness or similarity or dirivitive of".
My purpose is to check all new business names we see for upcoming
transactions against a list of known fraudulant names. The scammers seem to
use variations of a few company names over and over.. Thank you, tp