Gary, I haven't got a copy of SQLServer books online (BOL) here but is what you're trying to do also possible using inlfection and freetext ?
SELECT col1, col2 from tbl WHERE CONTAINS(col1, 'FORMSOF(INFLECTIONAL, nurse) AND FORMSOF(INFLECTIONAL, hospital)') etc? just a thought. barry.b -----Original Message----- From: G A R Y C R O U C H [ A I T ] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 20 April 2004 9:35 AM To: CFAussie Mailing List Subject: [cfaussie] MS SQL Soundex 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 --- 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
