Loading lesson path
Concept visual
Start at both ends
Extract 3 characters from a string, starting in position 1:
SELECT SUBSTRING('SQL Tutorial', 1, 3) AS ExtractString;The SUBSTRING() function extracts some characters from a string.
string, start, length )
Required. The string to extract from start Required. The start position. The first position in string is 1 length Required. The number of characters to extract. Must be a positive number
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Extract 5 characters from the "CustomerName" column, starting in position 1: SELECT SUBSTRING(CustomerName, 1, 5) AS ExtractString
FROM Customers;Extract 100 characters from a string, starting in position 1:
SELECT SUBSTRING('SQL Tutorial', 1, 100) AS ExtractString;❮ SQL Server Functions