 <blockquote> <p>select * from table_name order by cast (PARTICULARS as int) asc</p> </blockquote> <p><strong>You should type cast varchar to int or float to sort.</strong>.</p> <p>Hope it does good for you.</p>