just testing this function and have a question why result TO_BYTES is giving me slightly diffrent value.
select hash_md5('8009304000003022'), CAST (TO_BYTES (hash_md5('8009304000003022'), 'base16') as BYTE (16));
I have number of HASH_MD5 values loaded to TD as BYTE(16) and would like to join using this function.