I'd like to sort a recordset in numerical order instead of ASC or DESC.
Example 1, 2, 3, 9, 12.
Instead of 1, 12, 2, 3, 9 or the reverse.
Can anyone point me in the rigth direction.
Thanks

ASC is the equivalent to incrementally (low number to highest)
DESC is the equivalent to decrementally (high number to lowest)

ASC and DESC should work fine to sort numerical values.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

All depends on what is the type of DB field. If it's text then sorting will be like alphabetic (1, 12, 2, 3, 9). On the other hand, if field is numeric the data will be sorted as numbers (1, 2, 3, 9, 12).

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I'd like to sort a recordset in numerical order instead of ASC or DESC.
Example 1, 2, 3, 9, 12.
Instead of 1, 12, 2, 3, 9 or the reverse.
Can anyone point me in the rigth direction.
Thanks
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
www.farcic.com
TalkZone Manager

thanks, that was my error, non-numeric field