21

CHAPTER 21

String Functions

Manipulating and transforming text data.

Learning Blocks

Interactive Queries

Concepts you'll master

UPPER, LOWER, TRIM — basic cleanup

CONCAT — combining strings

SUBSTRING, LEFT, RIGHT — extracting parts

REPLACE, INSTR — search and replace

SQL QUERY

SELECT CONCAT(name, ' — ', city, ', ', country) AS profile
FROM customers;

Practice your SQL skills

SQL EDITOR

Interactive Query Environment

Press semicolon (;) to auto-run query

Complete all SQL challenges

Convert all employee names to uppercase.

Current Task

Convert all customer names to lowercase.

Find the length of each employee's name.

Combine employee name and department into a single column.

Extract first 3 characters of each customer's city.

Need help solving this task?