Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nasty index, any better ideas?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00817470
Message ID:
00817489
Views:
12
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform