Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Nasty index, any better ideas?
Message
From
06/08/2003 17:33:24
Bruce Kuyper
Summit Datanet
Helena, Montana, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Nasty index, any better ideas?
Miscellaneous
Thread ID:
00817470
Message ID:
00817485
Views:
21
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
Bruce
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform