• Of course these questions aren't about just running the SQL 🙂

    The question's main intent is clear, it's a pretty simple question about ALL - and I am not at all trying to be nitpicky or garner extra points or anything - it was just that in trying to work it out *in my head *, I noticed the case, noticed that it could affect the comparison, noticed that there wasn't enough info to deduce the whether the comparison would be case-sensitive or not - and thought that that might be an interesting *addendum/comment* to the main point.

    Maybe that's just because I have been caught by tables with case sensitive collations in real life.

    Kirsty

    EDIT: typo + reword for clarity of intent.