>>That's interesting.
>>I tried some searching but I can't find anything about what Type 'Hello' is.
>>I assume it's CHAR() but if it works where other CHAR() don't, I wonder.
>
>Hello is just a string.

https://docs.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver15
Actually, while the string type exists in .NET, there's no string type in TSQL.
I've searched to find out what type 'X' is in TSQL but can't find it.