-- If you just wanted to use the Shared Method to Compress Binary data, you -- can do the following. DECLARE @DocumentCompressed varbinary(max); SET @DocumentCompressed = VarBinaryComp::Compress(@Document);