which can be anything from a sequential number to an alphanumeric string. For instance, I have seen the following used: Due to the variety of numbering schemes used, the MS SQL Server data type ...

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