Information générale
Catégorie:
Codage, syntaxe et commandes
Just my £0.07 worth here.
I almost never use select statements when the data is this fuzzy.
If you just need to do a one off translation of the data and don't mind waiting for it then write a scan loop with a series of case statements for the logic that you have established so far.
Then just hone the logic down until you get fewer and fewer unmatched records.
Good Luck
>This may sound silly but the only basis here is that I know the reocrd exisit in my look up table. I know it is there somewhere but it has a MID that i a little different from the one I was provided with. I am looking for something close in most cases but can't always rely on that becasue there may be a 555585555 and a 555595555 that are two totally different people. As far as the MID length, it can be 1 to 16 characters in length. The only rule there is in this case is that the MID can have a length over 16 characters.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement