InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 18:09:36 GMT20http://www.sqlservercentral.com/Forums/Topic692812-338-1.aspxThanks kruti, it works.Wed, 08 Apr 2009 03:46:43 GMTbaumgaertnerhttp://www.sqlservercentral.com/Forums/Topic692812-338-1.aspxTry this,select sum(Convert(bigint,datalength(memTest),0))from tblTestWed, 08 Apr 2009 02:26:28 GMTKruti Kansarahttp://www.sqlservercentral.com/Forums/Topic692812-338-1.aspxHi,According to BOL, DataLength returns either an int or bigint depending upon the type of the field it is examining. So what is the definition of 'memTest' and how many rows are there?It could be that it is going to return an int, but the accumulated value is too large for such a field.BrainDonorWed, 08 Apr 2009 01:58:08 GMTBrainDonorhttp://www.sqlservercentral.com/Forums/Topic692812-338-1.aspxHello,when I try the following sql I get an error:[i]select sum(datalength(memTest))from tblTestArithmetic overflow error converting expression to data type int[/i]Has anyone an idea?Thanks.Wed, 08 Apr 2009 01:31:12 GMTbaumgaertner