The function as written also returns 1 for the empty string ''.

Interesting application of Tally, but when I am looking for issues like this I just cast into varbinary and compare the resulting hex strings. This seems much simpler than...