Sql - UPPER, LOWER, LENGTH and TRIM
Code Life
By Pierre Marsaa
Hand-typed data
Field agents report wild Codémon sightings from their phones — and type however they like. Welcome to messy data:
Loading data...
The same reporter appears as ' alex', 'alex' and 'Alex'. To a database, these are three different values. Look what that does to a count:
↗️
Loading editor...
↶
↷
11 "different" reporters for 4 real people. String functions exist to fix exactly this kind of problem.
The official list
The codemon table is the clean reference (name, type, level). At the end of the lesson you will match the messy reports against it.
Verify