Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incremental search on numeric
Message
From
04/04/2003 12:11:52
Sergey Berezniker
New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Incremental search on numeric
Miscellaneous
Thread ID:
00774073
Message ID:
00774091
Views:
14
>Index on padl(alltr(STR(SkNo)),4,'0') Tag SkNoA

The PADL/PADR function accept numbers as a first parameter.
Index on padl(SkNo,4,'0') Tag SkNoA
>
<snip>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform