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.

2026. g. 8. maijs1 min lasīšanaSQL · 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.

Praktizējies ar reāliem uzdevumiem

Risini uzdevumus SQL trenažierī ar tūlītēju novērtēšanu un padomiem.

Atvērt trenažieri