>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. It's the famous Hello Word test used everywhere. When entered as a string, it works. But, when I try to establish a real life scenario, such as taking the data from the table field itself, this is where this syntax doesn't work.