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 |
|
momoparigo
Starting Member
2 Posts |
 Posted - 2010-07-16 : 16:36:07
|
| Hi all,I'm working on an Access database that will be filled by user without any SQL or Access knowledge.I want to add information in a table from a user filled form but I would like to be sure the information is not already in the table.Furthermore I assume that the user may certainly mistype when entering data in the form.My question is then : is there any way to compare two "small" strings (maybe one or two words) in a more efficient way than just using LIKE and & to detect a typo and prompt the user with the lookalike entry that already exist in the table? thanks everybody ! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-07-17 : 08:31:01
|
| sounds like what you're looking for is a fuzzy matching algorithm------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-17 : 09:06:25
|
| can you provide some examples? |
|
|
|
momoparigo
Starting Member
2 Posts |
Posted - 2010-07-19 : 09:49:01
|
| I've search a little about fuzzy matching and found a code that's doing fairly what I want.thank's for the advice ! |
|
|
|
|
|
|
How to avoid typo from a user input