Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-30 : 08:06:20
|
| Matt writes "Hi,I would like to be able to implement a search which if it cannot find an accurate match, offers some 'best fit' suggestions.This would mean that if the person entered the search criteria of "Nottinham" the results would return the closest matches it could find : "Nottingham", "Nottinghamshire" etc.CheersMatt." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-09-30 : 10:23:49
|
| Have a look at the SOUNDEX function....it might be close to what you want. |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-09-30 : 11:11:30
|
| By Ken Hendersons book, The Guru's guide to SQL Server Stored Procedures, XML and HTMLThen go to chapter 19.He has a sample on exactly how to do spell checking using COM automation...Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
|
|
|
|
|
|
Spell Checker style search query