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 qariSQL · string · functions · tutorial
Ipprattika fuq eżerċizzji reali
Solvi eżerċizzji fit-taħriġ tal-SQL b'valutazzjoni u għajnuniet istantanji.
Iftaħ it-taħriġ
These are the three most basic string functions.
LOWERconverts to lowercase,UPPERto uppercase,LENGTHcounts 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.