SQL Doesn’t Work in Scotland

Select name

From Employee

Where name > “Mc” and name < “Md”

OrderBy name

Doesn’t work for the McAndish clan:

(they’re all the same!)

McAndish

MacAndish

M’Andish

Comparison based on ASCII

Other countries are even more problematic.

Previous slide

Next slide

Back to first slide

View graphic version