I have to look for similar spellings of words within a description field of many characters.
I know how to use t-sql DIFFERENCE when matching word-for-word: select from oneWordField where DIFFERENCE( oneWordField, @mySearchTerm ) >= 3 But how would one implement DIFFERENCE when looking for a like word in a field of many characters, for ex. find "Smythe" in "A description of the life and times of John Smith"? (Without having to loop thru and test each word.) Thanks, Noahs Arkive "It's better to swim than sink!" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2849 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
