LEN · SUBSTRING · UPPER · LOWER · Concatenation
| Function | What it does | Example → Result |
|---|---|---|
| LEN(str) | Returns the length (number of characters) | LEN('Hello') → 5 |
| SUBSTRING(str, start, len) | Extracts characters from position start, length len | SUBSTRING('Hello',1,3) → 'ell' |
| UPPER(str) | Converts all characters to uppercase | UPPER('hello') → 'HELLO' |
| LOWER(str) | Converts all characters to lowercase | LOWER('HELLO') → 'hello' |