General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only