I am not sure that I can do the port, but hopefully someone on this forum will read the message and port it for you. I will keep my eye...

Are there any plans to release a version of "Metaphone 3" in T-SQL? We will not be including the code in a product or web page.

The regex expression works in most cases, but our current non-regex solution is a bit more robust and accounts for irish surnames and italian surnames when no apostrophe is present...

Thank you, Alan... that helps. Looking forward to taking a look at the regular expression if you can find it.

Scott -

Thanks for the reply. The issue is that there may be records in t1 that are not in t2, and vice-versa; therefore, I need to consolidate both tables, and...