✂️
Beginner About 15 min
String Functions
Clean and reshape text data with UPPER, LOWER, TRIM, CONCAT, SPLIT_PART, and case-insensitive matching.
What you'll learn
- Change text case with UPPER, LOWER, and INITCAP
- Concatenate strings with || and CONCAT (NULL-safe)
- Clean text with TRIM, LTRIM, RTRIM, and REPLACE
- Extract substrings with SPLIT_PART and SUBSTRING
- Search text with LIKE and case-insensitive ILIKE