Does casing matter when selecting the names?


#1

Question

In the context of this code challenge, does casing matter when selecting the names?

Answer

No, casing does not matter for the names. This is because SQL is case-insensitive for text values.

For example, the following queries should return the same results,

SELECT *
FROM babies
WHERE name = "ALICE";

SELECT * 
FROM babies
WHERE name = "Alice";