Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Nasty index, any better ideas?
Message
 
À
06/08/2003 17:33:24
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00817470
Message ID:
00817489
Vues:
13
>This seems to work, and it's a little simpler, but I'm not sure it meets your criteria for non-standard VFP functions.
>
>
INDEX ON IIF(ISALPHA(CatNumber), CatNumber, PADL(TRIM(CATNUMBER), 4, '0')) TAG CatNumber
Hi Bruce (not actually talking to myself :-). That one I believe I tried also, or one very similar, anyway - but this approach falls down within the alpha sorts. You get a result like:

B1, B13, B2

for example...

(After-Note: apologies for not including this exact situation in the test data points. Please consider them as added to the original list for testing...)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform