Hi there

I'm using an updateable numbered sequence to order a recordset using asp and MS SQL Server 2000.

i.e

Select * from cars order by Sequence

It's all fine except when the amount of records goes into double figures i.e 10 and then the sequence doesn't follow - 10 becomes the second recordset to appear?

Any ideas greatly appreciated.

thanks

Adam

Use the query

Select * from cars order by len(sequence),Sequence

That will surely work.
100%.
Pls revert.


Ashwin S.Kenkare
Programmer
CMI