How does varchar equality work in SQL and why? '1' is different from '1 ' actually. See the spaces in the right hand side operand:

```
SELECT CASE 
       WHEN '1' = '1    ' THEN 'yes'
       ELSE 'no'
       END
-- results in yes

```

The output is 'yes', but why?