Posted by Plamen Ratchev on 04/10/07 21:05

You do not have to convert your BLOB column. DATALENGTH will return the
correct size of the BLOB column if you use it directly.

Something like this:

SELECT SUM(COALESCE(DATALENGTH(document), 0))
FROM plan_report

HTH,

Plamen Ratchev
http://www.SQLStudio.com

[Back to original message]