String functions are essential for cleaning, transforming, and analyzing text data in SQL. Each DBMS offers slightly different syntax, but the core idea is the same.<\/p>\n\n\n\n
\ud83d\udd39 Common String Functions with Examples<\/strong><\/p>\n\n\n\n \ud83d\udd39 Useful Real-World Examples<\/strong><\/p>\n\n\n\n \ud83d\udd39 Common Functions by DBMS<\/strong><\/p>\n\n\n\n \ud83e\udde0 Quick Recap<\/strong><\/p>\n\n\n\n \ud83d\udca1 Combine string functions to clean and format output for reports, UI, and validation rules.<\/p>\n","protected":false},"excerpt":{"rendered":" String functions are essential for cleaning, transforming, and analyzing text data in SQL. Each DBMS offers slightly different syntax, but the core idea is the same. \ud83d\udd39 Common String Functions with Examples \ud83d\udd39 Useful Real-World Examples \ud83d\udd39 Common Functions by DBMS Function MySQL \/ PostgreSQL SQL Server Length LENGTH() \/ CHAR_LENGTH() LEN() Substring SUBSTRING() \/ […]<\/p>\n","protected":false},"template":"","meta":{"googlesitekit_rrm_CAowu461DA:productID":""},"categories":[952,979],"class_list":["post-4005","cposts","type-cposts","status-publish","hentry","category-notes","category-sql"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts\/4005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/cposts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/cposts"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=4005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=4005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}-- Convert to upper\/lower case\nSELECT UPPER('sql tutorial'); -- SQL TUTORIAL\nSELECT LOWER('SQL TUTORIAL'); -- sql tutorial\n\n-- Get string length\nSELECT LENGTH('Hello'); -- MySQL\/PostgreSQL\nSELECT LEN('Hello'); -- SQL Server\n\n-- Concatenate strings\nSELECT CONCAT(first_name, ' ', last_name) FROM employees; -- MySQL\/PostgreSQL\nSELECT first_name + ' ' + last_name FROM employees; -- SQL Server\n\n-- Substring\nSELECT SUBSTRING('Database', 1, 4); -- Data (All DBs)\nSELECT SUBSTR('Database', 1, 4); -- MySQL\/PostgreSQL alternative\n\n-- Replace text\nSELECT REPLACE('Learn SQL', 'SQL', 'Python'); -- Learn Python\n\n-- Trim spaces\nSELECT TRIM(' SQL '); -- SQL (removes both ends)\nSELECT LTRIM(' SQL'); -- Removes leading spaces\nSELECT RTRIM('SQL '); -- Removes trailing spaces\n\n-- Position of substring\nSELECT POSITION('a' IN 'Database'); -- 2 (PostgreSQL)\nSELECT CHARINDEX('a', 'Database'); -- 2 (SQL Server)<\/code><\/code><\/pre>\n\n\n\n-- Get domain from email\nSELECT SUBSTRING(email, POSITION('@' IN email) + 1) FROM users;\n\n-- Concatenate first and last name\nSELECT CONCAT_WS(' ', first_name, last_name) FROM employees; -- MySQL\n\n-- Clean user input\nSELECT TRIM(LOWER(username)) FROM users;<\/code><\/code><\/pre>\n\n\n\nFunction<\/th> MySQL \/ PostgreSQL<\/th> SQL Server<\/th><\/tr><\/thead> Length<\/td> LENGTH()<\/code> \/ CHAR_LENGTH()<\/code><\/td>LEN()<\/code><\/td><\/tr>Substring<\/td> SUBSTRING()<\/code> \/ SUBSTR()<\/code><\/td>SUBSTRING()<\/code><\/td><\/tr>Concatenation<\/td> CONCAT()<\/code> \/ `<\/td><\/td><\/tr> Replace<\/td> REPLACE()<\/code><\/td>REPLACE()<\/code><\/td><\/tr>Position<\/td> POSITION()<\/code><\/td>CHARINDEX()<\/code><\/td><\/tr>Trim<\/td> TRIM()<\/code>, LTRIM()<\/code>, RTRIM()<\/code><\/td>Same in SQL Server<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Task<\/th> Example<\/th><\/tr><\/thead> Convert Case<\/td> UPPER()<\/code>, LOWER()<\/code><\/td><\/tr>Find Length<\/td> LENGTH()<\/code>, LEN()<\/code><\/td><\/tr>Cut Substring<\/td> SUBSTRING('SQL', 1, 2)<\/code><\/td><\/tr>Replace Text<\/td> REPLACE('SQL', 'S', 'P')<\/code><\/td><\/tr>Concatenate Values<\/td> CONCAT(first, last)<\/code><\/td><\/tr>Trim Spaces<\/td> TRIM(' SQL ')<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n