Alla inlägg
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.

1 min läsningSQL · 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.

Öva på riktiga uppgifter

Lös uppgifter i SQL-tränaren med omedelbar rättning och ledtrådar.

Öppna tränaren