How weird. A dev is trying to query a table using a string literal in a WHERE clause. But no rows are returned.
I suspected a non-printable ASCII character (codes 0 - 31) might be the issue. I copied/pasted the string literal into SSMS.
There's definitely an extra character at the left side of the string. But SQL thinks it's a question mark character, which is ASCII code 63. That's a 'visible' character...but I can't see it in SSMS, a browser, or Notepad.
*SQL Server Management Studio
Ah, I stand corrected. I couldn't see the character in Slack, but I can see it in a Github gist.
Still, I still think that first character should be a '?'...not a mystery red dot.
It's a silly/dumb mystery, I suppose.
If anyone wants a look, here's the gist link. It's easily reproducible in SSMS.
https://gist.github.com/BeginTry/61ffbdd4864452a69a8f35a138725507
Haaa! There's more!
The mystery character is only visible while creating/editing the gist. Upon saving, it's no longer visible. Not even when viewing Raw.