Search code examples
sqlsql-serversql-server-2005clr

Size of VARBINARY field in SQL Server 2005

I am trying to determine the size in bytes of the contents in a VARBINARY(MAX) field in SQL Server 2005, using SQL. As I doubt there is native support for this, could it be done using CLR integration? Any ideas would be greatly appreciated.

Solution

  • Actually, you can do this in T-SQL!

    DATALENGTH(<fieldname>) will work on varbinary(max) fields.