As you can tell, you'll need to actually adjust these numbers so that ASCII 57 and number 57 are not equivalent. Another way of doing the same thing for SQL is to make a column for sorting and pad ...

BR>So, I changed some fields to numeric(8,2), hoping that would help ... BR><BR>So, is there a way to get SQL Server 2000 to return 0.00 as the value instead of .00? I wasn't expecting this ...