InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 10:30:40 GMT20http://www.sqlservercentral.com/Forums/Topic692937-150-1.aspxThanks Steveb . Its workingWed, 08 Apr 2009 06:08:10 GMTArunkumar S Phttp://www.sqlservercentral.com/Forums/Topic692937-150-1.aspxIt depends, it you are only storing Numbers in the column then the datatype should be really a Numeric data type.Otherwise i would do a conversion on the stored procedure/ View that you use to access the data.Wed, 08 Apr 2009 05:19:19 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic692937-150-1.aspxThanks for your quick respone. Where to convert ? . In sql(dataset) or by using expression.Wed, 08 Apr 2009 05:16:06 GMTArunkumar S Phttp://www.sqlservercentral.com/Forums/Topic692937-150-1.aspxIt looks like the numbers are stored in a Char/Varchar column.Convert them to an Integer then sort by the Integer data.Wed, 08 Apr 2009 05:13:25 GMTsteveb. http://www.sqlservercentral.com/Forums/Topic692937-150-1.aspxHi All,I kept sorting for S.No in my report. While i'm sorting the numbers are sort in 1,10,100,2,20,3,30 order but i want 1,2,3,10,20,30,100. Please help me to solve this issueWed, 08 Apr 2009 05:09:51 GMTArunkumar S P