I use an application that stores a file path as hexadecimal converted to decimal. So, a file path of \00\00\05\B4 would be stored in the database (slashes are not stored) as 1460. I can convert this using cast(column as varbinary(8)) but I would like to convert it to text so I can provide the actual path using concatenation instead 0x000005B4. When I try to cast the above cast to varchar, it returns a blank. Is there a way to convert varbinary to text so I can parse it in the query and return a path string?