SQLstringfunctionstutorial

What are LOWER, UPPER, LENGTH in SQL? String functions for beginners

String functions are a daily SQL tool: case normalization (LOWER, UPPER), length (LENGTH), whitespace trimming (TRIM), substrings (SUBSTRING), replace (REPLACE). Plain words: case-insensitive search, data cleanup, and Unicode gotchas.

8 mai 20261 min de lectureSQL · string · functions · tutorial

These are the three most basic string functions. LOWER converts to lowercase, UPPER to uppercase, LENGTH counts the length. Plain, but exactly where real data work begins: email normalization, whitespace cleanup, case-insensitive search.

This article is currently in Russian. The full English translation is on the way.

Entraînez-vous sur de vrais exercices

Résolvez des exercices dans l'entraîneur SQL avec évaluation et indices instantanés.

Ouvrir l'entraîneur