Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql order by
Message
From
11/12/2006 04:59:46
Mk Sharma
Shrishti Solutions
Mumbai, India
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sql order by
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
SAMBA Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01176457
Message ID:
01176457
Views:
54
i want to create a sql statement for character field with index.

sele accode, billdate, billno, amt from xcash2 group by accode, billno into curs ccust order by billdate,billno

billno is a character field.

this showing billnos
1
10
11
12
13
14
15
16
17
18
19
2
20
21

but i want to see like :
1
2
3
4
5
6


warm regards,
mk.
Next
Reply
Map
View

Click here to load this message in the networking platform