SQLServer 에서 HASHBYTES 함수로 SHA2_265 hash 생성하면 0x3FC9B689459D738F8C88A3A48AA9E33542016B7A4052E001AAA536FCA74813CB 처럼 0x 문자열이 붙는데 어떻게 제거하나요?
SELECT HASHBYTES('SHA2_256','something');
SELECT CONVERT(VARCHAR(50), 0x3FC9B689459D738F8C88A3A48AA9E33542016B7A4052E001AAA536FCA74813CB, 2); -- 3FC9B689459D738F8C88A3A48AA9E33542016B7A4052E001AAA536FCA74813CB
SELECT CONVERT(VARCHAR(50), 0x3FC9B689459D738F8C88A3A48AA9E33542016B7A4052E001AAA536FCA74813CB, 2); --