When you define a column in MS SQL server as either decimal or numeric (these are both options but do the same thing) you need to define a fixed precision and scale value for that column.

When selecting the data, I was expecting the zero values to be returned as 0.00 or 0, but they were returning as .00.<BR>So, I changed some fields to numeric (8,2), hoping that would help.