String Functions

Learn about SQL string manipulation functions to extract and format data from tables and in stored procedures.

Title Author Date
SQL Server Char Function and Reference Guide Joe Gavin2026-06-24
SQL Coalesce Function Examples and Use Cases Rajendra Gupta2026-06-24
SQL UPPER Function Use and Examples Daniel Calbimonte2025-04-27
SQL UNICODE Function Use and Examples Daniel Calbimonte2025-04-27
SQL TRIM Function Use and Examples Daniel Calbimonte2025-04-27
SQL TRANSLATE Function Use and Examples Daniel Calbimonte2025-04-27
SQL SUBSTRING Function Use and Examples Daniel Calbimonte2025-04-27
SQL STUFF Function Use and Examples Daniel Calbimonte2025-04-27
SQL STRING_ESCAPE Function Use and Examples Daniel Calbimonte2025-04-27
SQL STR Function Use and Examples Daniel Calbimonte2025-04-27
SQL SPACE Function Use and Examples Daniel Calbimonte2025-04-27
SQL SOUNDEX Function Use and Examples Daniel Calbimonte2025-04-27
SQL RTRIM Function Use and Examples Daniel Calbimonte2025-04-27
SQL RIGHT Function Use and Examples Daniel Calbimonte2025-04-27
SQL REVERSE Function Use and Examples Daniel Calbimonte2025-04-27
SQL REPLICATE Function Use and Examples Daniel Calbimonte2025-04-27
SQL QUOTENAME Function Use and Examples Daniel Calbimonte2025-04-27
SQL PATINDEX Function Use and Examples Daniel Calbimonte2025-04-27
SQL NCHAR Function Use and Examples Daniel Calbimonte2025-04-27
SQL LTRIM Function Use and Examples Daniel Calbimonte2025-04-27
SQL LOWER Function Use and Examples Daniel Calbimonte2025-04-27
SQL LEN Function Use and Examples Daniel Calbimonte2025-04-27
SQL LEFT Function Use and Examples Daniel Calbimonte2025-04-27
SQL FORMAT Function Use and Examples Daniel Calbimonte2025-04-27
SQL CONCAT Function Use and Examples Daniel Calbimonte2025-04-27
SQL DIFFERENCE Function Use and Examples Daniel Calbimonte2025-04-27
SQL DATALENGTH Function Use and Examples Daniel Calbimonte2025-04-27
SQL CONCAT_WS Function Use and Examples Daniel Calbimonte2025-04-27
SQL REPLACE Function Use and Examples Daniel Calbimonte2025-04-24
SQL STRING_AGG Function Use and Examples Daniel Calbimonte2025-04-23
SQL CHARINDEX Function Use and Examples Greg Robidoux2025-04-23
SQL CHAR Function Use and Examples Greg Robidoux2025-04-23
SQL ASCII Function Use and Examples Greg Robidoux2025-04-23