String functions help you manipulate text data in SQL. Essential for data cleaning and formatting.

CONCAT - Join Strings

SELECT CONCAT(first_name, ' ', last_name) as full_name FROM customers;

UPPER/LOWER

SELECT UPPER(name) FROM products;

SELECT LOWER(email) FROM customers;

LENGTH

SELECT name, LENGTH(name) as name_length FROM products;

SUBSTRING

SELECT SUBSTRING(phone, 1, 3) as area_code FROM customers;

TRIM

SELECT TRIM(name) FROM customers;

SELECT LTRIM(name), RTRIM(name) FROM customers;

REPLACE

SELECT REPLACE(phone, '-', '') FROM customers;

LEFT/RIGHT

SELECT LEFT(product_code, 3) FROM products;

SELECT RIGHT(product_code, 4) FROM products;

LOCATE/INSTR

SELECT LOCATE('@', email) FROM customers;

Generate String Queries

AI2sql applies string functions automatically.