Removing Padded Zeroes In Hexadecimal Column

I have a database in TSQL that contains columns in hexadecimal. However these values are padded with zeroes to fill the column. I need to remove these zeroes just so I have the hex

Solution 1:

Maybe this will be good for you:

Select  replace(rtrim(replace('C700DBBF000000','0',' ')),' ','0');