>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.
SELECT *, PADL(ALLTRIM(billno),6,[0]) AS OrdBy FROM ..... ORDER BY OrdBy
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.