SQL - String Functions

Overview

String functions manipulate text. Not all functions are identical across engines, but core capabilities exist.

SELECT UPPER('abc'), LOWER('ABC'), LENGTH('Hello'), TRIM('  hi  ');
SELECT SUBSTRING('abcdef', 2, 3);

SELECT UPPER('abc'), LOWER('ABC'), LEN('Hello'), LTRIM(RTRIM('  hi  '));
SELECT SUBSTRING('abcdef', 2, 3);

SELECT UPPER('abc'), LOWER('ABC'), LENGTH('Hello'), TRIM('  hi  ');
SELECT SUBSTR('abcdef', 2, 3);

upperc	lowerc	len	trimmed
ABC	abc	5	hi

substr
bcd