Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Chan Kok Kiet
  Where is Chan Kok Kiet?
 Kuala Lumpur
 Malaysia
 Chan Kok Kiet
 To: yusito
  Where is yusito?
 Denpasar
 Indonesia
 yusito
 Tags
Subject: RE: HOW TO SORT RECORD ACCORDING TO A FIELD
Thread ID: 33943 Message ID: 33974 # Views: 1 # Ratings: 0
Version: Visual FoxPro 7 Category: Reports and Printers
Date: Friday, December 05, 2003 3:26:18 PM         
   


Hi,
Try
INDEX ON RIGHT(myField, 3) TAG myIndex
SET ORDER TO myINdex

> I have a field that contains combination character and numeric expression like this
> A003
> U001
> H004
> S002
> I want that sort the record according to the last 3 digit (numeric expression), as below
> U001
> S002
> A003
> H004
> How can I do that ?
>
> Al Walaad


I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...

ENTIRE THREAD

HOW TO SORT RECORD ACCORDING TO A FIELD Posted by Al Walaad @ 12/5/2003 10:21:22 AM
RE: HOW TO SORT RECORD ACCORDING TO A FIELD Posted by Chan Kok Kiet @ 12/5/2003 3:26:18 PM
How to apply the index in a report Posted by Al Walaad @ 12/8/2003 2:12:21 AM
RE: How to apply the index in a report Posted by Rene Relucio @ 12/8/2003 4:12:01 AM