 <p>I think your id column is varchar it schould be int </p> <p>but maybe did can help you</p> <p><a href="http://support.microsoft.com/kb/209632" rel="nofollow">http://support.microsoft.com/kb/209632</a></p> <p>to order string as numeric</p>