I have a SQL statment that I'm using the AVG function on, but it's rounding the results to the nearest whole number and I'm not sure why. My query is this: SELECT AVG(dbo.fn_GetBusDays(Date_Identified, Pending_Closed_By_Date)) AS WorkDays FROM dbo.tblCAP_Capa WHERE (Initiated_By_Date BETWEEN '4/1/2009' AND '4/30/2009') If it matters, dbo.fn_GetBusDays is a scalar function that returns an integer - it just calculates the number of working days between two dates. Individualy, the record values are 22, 19, and 12 (calculated by the function), which should average out to 17.6666..., but 17 is what shows up when I run it. It even rounds when I divide the COUNT by the SUM ie. SUM(dbo.fn_GetBusDays(Date_Identified, Pending_Closed_By_Date))/COUNT(CAPA_Number). In this case, I need to round to one decimal point (looking for 17.7). I even tried throwing ROUND(x,1) in various spots, but to no avail. Is there a setting somewhere that I am missing or is there something else that is less obvious to me that I am doing wrong. Thanks in advance for any insight.