MSSQL Server Aggregate function over column defined as varchar

The goal is to calculate the aggregate functions (sum, avg) over a column which is defined as varchar

Taggings:

Submitted by Jürgen Bulla on Tue, 12/13/2011 - 21:41
1 answer

how to convert column to execute aggregate function

example:
CONVERT(varchar(50),SUM(convert(float,replace(ISNULL( column, 0 ),',','.')))) as SUM

Submitted by Jürgen Bulla on Tue, 12/13/2011 - 22:01

Taggings: