• Carlo Romagnano

    SSC-Insane

    Points: 21692

    The return type is VARBINARY(MAX) , so, it should be CASTed to a char type.
    Also, there's an undocumented function UNCOMPRESS.
    select UNCOMPRESS(decompress(COMPRESS('a')))
    Try: it returns the starting string.