I found this solution interesting, but I was especially intrigued by the inconsistent results.  So I did my own testing by breaking down the solution.
I suspect the reason some...

It seems to me the answer to this question is more about string manipulation through data type conversion than it is about String_Split function.  And by altering the source string...

This is an interesting discussion and clearly it is very easy to see why it can be confusing.

From a value perspective the 2 HEX numbers are the same. They both...