Compress: Compresses input data and returns the binary data of type VARBINARY(MAX)
Decompress: Decompresses compressed input binary data and returns the binary data of type VARBINARY(MAX)
Here is small example in SQL Server 2016:
SELECT COMPRESS ('Data To Compress')SELECT DECOMPRESS (Binary Data To Decompress)