Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01610714
Message ID:
01610717
Views:
61
thanks Hugo. It looks like it should work, I get it, but I am still left with the same order as a normal index.
must be missing something.
k

>Not that I recommend it, but you could do:
>
>
>index on iif(left(myfield, 1) = '/', myfield + space(1), '?' + myfield) tag mywierdindex
>
>
>So if myfield starts with a slash we add a space to the end of the string, if it is not we add a question mark (or any other character whose ASCII value is greater than the ASCII value of the slash) at the beginning (the space is added so both strings have the same length)
>
>But I think you should look into other solutions.
Previous
Reply
Map
View

Click here to load this message in the networking platform