Hi all, Has anyone had much experience with soundex in MS SQL?
I want to check that a sub string say "smith" is in a company name say "Albert Smith Signs Group" thas easy. companyName = '%smith%' On top of that I want to pull "Albert Smith Signs Group" when the sub string is "smyth" ie it sounds like "smith" but is different spelling. I can see that one way would be to loop round the content of 'companyName' as a space delimeted list and soundex() against each word, this i fear will take to long to execute. So I am after a more direct aproach anyone know of one? GC. 0408883932 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
