I am using Sql Server 2000. I have a column with records in a 999.99 format, I have that column as a nvarchar datatype because I don't get to much problems when I code. My question is that when I query that column in asc or desc it seams to asc/desc by the first number and not by the whole number:<BR><BR>0<BR>1<BR>10.9<BR>11.6<BR>19<BR>2<B R>20.6<BR>26<BR>3<BR>30.5 <BR><BR>Is the reason for this the datatype selected. please let me know what I should be doing to get the column to asc/desc properly... Thanks for you time and help.