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 ...

n specifies the number of double-byte characters and can range from ... For more information about SQL data types, datetime formats, and edit codes that are used in the United States and other ...

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 ...