Is this what you mean?

CREATE TABLE #T(tmessage VARCHAR(200))

INSERT INTO #T

SELECT 'Short' UNION ALL

SELECT 'Longer' UNION ALL

SELECT 'Even a longer message' UNION ALL

SELECT 'A realy realy realy extra long message'

select SUM(200 -Len(tmessage)) AS WASTED,AVG(200 -Len(tmessage)) AS 'Average Wasted'

FROM #T

DROP TABLE #T

The results:

WASTEDAverage Wasted

730 . . . . . 182

If not then please refer to the link in my signature block and post the table definition, some sample data, so that those who want to help you can help you .