Lesson 8 of 20

Clean and assemble text

Normalize labels with TRIM, UPPER, LOWER, LENGTH and concatenation.

27 minDiscovery access

By the end of this lesson

  • Clean stray spaces
  • Uniform case
  • Build a label without losing values NULL

Free Discovery access

Create your space to open this lesson.

Clean and assemble text is one of 8 lessons and 15 free exercises linked to an account. No card is required.

30 free days of SQL Pro on registration, subject to the 33 remaining places. No card or automatic renewal.

Create my Discovery spaceI already have an account
After signing in, you will return directly to this activity.