Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search
Jet SQL fuzzy search Jet SQL fuzzy search
Jet SQL fuzzy search
Go Back  Xtreme Visual Basic Talk > > > Jet SQL fuzzy search


Reply
 
Thread Tools Display Modes
  #1  
Old 01-24-2017, 09:10 AM
Daigon Ali Daigon Ali is offline
Regular
 
Join Date: Aug 2014
Location: London
Posts: 50
Default Jet SQL fuzzy search


Hi All,

I have a database which contains makes and models. The users have to be able to add new makes and models when appropriate but, as you might anticipate, the same make/model is being entered multiple times with small variations.

I've applied the usual trim, case insensitivity, multiple spaces etc but it's preventing any usable reporting based on the make/model values due to these variations.

I've changed the interface to indicate when a new make/model is being entered and would also like to display a list of similar makes/models which already exist for the user to choose from.

The problem is that Jet SQL via ADO doesn't appear to be able to perform a fuzzy enough search.
I've tried the LIKE operator with various wildcards, but it needs more.

Any help much appreciated.
Reply With Quote
  #2  
Old 09-14-2017, 03:45 AM
gibra's Avatar
gibra gibra is offline
Junior Contributor
 
Join Date: Apr 2008
Location: Italy
Posts: 385
Default

We can't help you if you doesn't shows us:
1) SQL query you use
2) list of data (table/database)
Reply With Quote
Reply

Tags
make/model, jet, entered, multiple, models, search, fuzzy, sql, makes, variations, choose, similar, list, display, exist, makes/models, user, wildcards, appreciated, operator, ado, perform, spaces, anticipate, times


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search Jet SQL fuzzy search
Jet SQL fuzzy search
Jet SQL fuzzy search
 
Jet SQL fuzzy search
Jet SQL fuzzy search
 
-->