>>>I'm using Craig Boyd's FLL to create a SHA-256 hash code. After I call it with HASH(m.lcHashme, 2) , it returns:
>>>
>>>"ƒ]ÊQ“öu 9/s¦«†8‚žZ¸™€Ç)ÚSìˆÅ"
>>>
>>>If I then encode it to hexBinary using STRCONV("ƒ]ÊQ“öu 9/s¦«†8‚žZ¸™€Ç)ÚSìˆÅ", 15) I get:
>>>
>>>"835DCA0E5193F675A0392F73A6AB118638829E5AB89980C729DA05538DEC88C5"
>>>
>>>The issue that I'm having is that I'm supposed to get "52e7e37b8c5f6cde8505a9d4a6324ca486d5aa13dde18cb7fa58690978343f72" because the web service that I'm going to call generates the latter. If it helps, I've been told that the web service generated the value from the hash code in bytes: 82 -25 -29 123 -116 95 108 -34 -123 5 -87 -44 -90 50 76 -92 -122 -43 -86 19 -35 -31 -116 -73 -6 88 105 9 120 52 63 114
>>>
>>>I'll be the first to admit that I'm clueless about this stuff and any assistance would be greatly appreciated.
>>
>>Maybe the web service is using a hash that is actually something different from what Craig's FLL calls SHA-256? Just for grins, maybe you could spin through all the options for HASH() and see if any of the results match what you're supposed to get.
>
>
>That thought did cross my mind :(
>I figured that before I went to that extreme, I'd ask around.

Well, it's not much of an "extreme" - HASH() supports only 7 different types, it would take you only seconds to try them all against what the web service gives you.