SQL Server SUBSTRING() Function | sql substring index
ExampleExtract3charactersfromastring,startinginposition1:SELECTSUBSTRING(SQLTutorial,1,3)ASExtractString;TryitYourself»[1]DefinitionandUsageTheSUBSTRING()functionextractssomecharactersfromastring.SyntaxSUBSTRING(string,start,length)ParameterValuesParameterDescriptionstringRequired.ThestringtoextractfromstartRequired.Thestartposition.Thefirstpositioninstringis1lengthRequired.Thenumberofcharacterstoextract.MustbeapositivenumberTechnicalDetailsWorksin:SQLServer(startingwith2008),AzureSQLDatabas...
ExampleExtract 3 characters from a string, starting in position 1:
SELECT SUBSTRING(SQL Tutorial, 1, 3) AS ExtractString;
Try it Yourself »[1] Definition and UsageThe SUBSTRING() function extracts some characters from a string.
SyntaxSUBSTRING(string, start, length)
Parameter Values Parameter Description string 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 Technical Details Works in: SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse More Examples ExampleExtract 5 characters from the "CustomerName" column, starting in position 1:
SELECT SUBSTRING(CustomerName, 1, 5) AS ExtractStringFROM Customers;
Try it Yourself »[2] ExampleExtract 100 characters from a string, starting in position 1: