Thanks for the reply blindman, however this appears to sum the fields rather than count them. Have I misunderstood?
E.g If the sume of the fields is 16 and there are 6 columns the answer is 2.66. If however the 16 is made up of values from only 5 of the six columns the answer is 3.2 (this if the 6th column is a 0 value).
REally appreciate your help
Originally posted by blindman
(isnull(nullif(Column1, 0), 0) + isnull(nullif(Column2, 0), 0)...isnull(nullif(ColumnN, 0), 0))
You can omit the isnull functions if you are sure your columns do not contain NULLs, but it is safest to leave it in.