Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Easy Index Question
Message
From
28/12/2004 11:58:08
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Easy Index Question
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00972616
Message ID:
00972616
Views:
50
Hello,

I'm trying to create an index...

proj_desc+alltrim(str(storenbr))

...where proj_desc is character and storenbr is numeric.

As you can guess, it sorts the storenbr by first character first...

1
10
100
11
20
200
3

How do I write the index expression to have it sort the numerics as numbers?

Thanks,
Martha
Next
Reply
Map
View

Click here to load this message in the networking platform