Computers are fascinating!
TIL 'a'='a '
is true in standards compliant SQL.
Turns out, if the strings are different lengths, one is padded with spaces before comparing them.
Was super confusing at first when RIGHT(Comment, 1)='; '
was finding results!