Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing
Message
From
08/11/2014 08:22:22
 
 
To
08/11/2014 04:46:08
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
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:
01610729
Views:
64
>>
index on left(chrtran(myfield,'/','') + ' ',25)
>
>Almost there, but missing a cherry on top:
>
>
index on padr(chrtran(myfield,'/',''),25)
>
>>Replace 25 with the actual length of your field.
>
>There.

Right. To be honest, I had a bad moment when I simply forgot about padr(). I bumped my head into the desk a few times, but just couldn't remember the name of that function. I remembered later, and thought about changing my message. However, you beat me.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform