Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Easiest way to do this search
Message
De
20/09/2018 15:24:01
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Easiest way to do this search
Divers
Thread ID:
01662162
Message ID:
01662162
Vues:
67
I am not sure the fastest way to do this kind of search in sql server, maybe a regular expression?

Let's say I have a 6 character varchar field. In that field are license plate nunbers, such as "L1 234", "QA3333", etc. Now the user enters via a telephone 6 numbers. (I cannot control the IVR portion and must deal with the 6 numbers.) Now given the phone pad, if a user enters "235466" that could really mean:
235466
A35466
B35466
C35466
2A5466
2B5466

etc for millions of combinations. I need to pull the recordfs that match any of those possibilities.

Comments?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform