Sql - UPPER, LOWER, LENGTH and TRIM
📖 Read the lesson
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...
↶
▶️ Run
↷
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