Name Recognition Patterns 1

[benaround]

I have a problem in using MS Access to perform a name recognition and lookup.
My data to find may looklike - BenAround.
I have to somehow match / find data that may looklike a) Ben Around b) Ben Arou c) or any number of other unususual combination in a SQL database.
What I am lookign for is an idea / concept on how to perform match recognition on names where the input data and database information has many variations not covered by normal join operations.
Thanks ahead of time for any info

 

[traingamer]

Do a search in the Access fora for Soundex or start with thread701-326595

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[benaround]

Thanks traingamer, I did not even know that there was a Soundex function. I started doing some searching and found the link

http://www.dhs.ca.gov/ps/ooa/HIVReporting/soundex/soundex.htm.

In combination with the code that you linked-to, I can do my project.