0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for practitioners of the art and science of signal, image and video processing

/*SELECT CAST((CAST(SUM(LEN(Text)) AS NUMERIC(38,0)))/COUNT(ID) AS DECIMAL(18,2)) AS CONT
FROM Comments*/

--SELECT SUM(CAST(LEN(Text) AS NUMERIC(38,0))) FROM Comments;

SELECT SUM(CAST(LEN(Text) as bigint)) FROM Comments;

SELECT COUNT(ID) FROM Comments;

SELECT TOP 5 TEXT FROM Comments

view current version

edited feb 14 13

created feb 14 13 hims056