Apr 16, 2025 · The SUBSTRING function returns a portion of a specified character, binary, text, or image expression.

T-SQL Scalar function: CREATE FUNCTION dbo.SUBSTRING_INDEX ( @str NVARCHAR(4000), @delim NVARCHAR(1), @count INT ) RETURNS NVARCHAR(4000) WITH SCHEMABINDING BEGIN DECLARE @XmlSourceString XML; SET @XmlSourceString = (SELECT N'<root><row>' + REPLACE( (SELECT @str AS '*' FOR XML PATH('')) , @delim, N'</row><row>' ) + N'</row></root>'); RETURN ...

Mar 1, 2021 · SQL Server provides many useful functions such as ASCII, CHAR, CHARINDEX, CONCAT, CONCAT_WS, REPLACE, STRING_AGG, UNICODE, UPPER for this purpose. In this article, we explore SUBSTRING, PATINDEX, and CHARINDEX using examples. The SUBSTRING () function extracts the substring from the …

The SUBSTRING () function extracts some characters from a string. Required. The string to extract from. Required. The start position. The first position in string is 1. Required. The number of characters to extract. Must be a positive number. Extract 5 characters from the "CustomerName" column, starting in position 1:

May 10, 2023 · The SQL Server SUBSTRING function extracts a portion of a string based on its starting position and length. The syntax for the SUBSTRING function is as follows: SUBSTRING (input_string, start_position, length)

Feb 28, 2025 · Understand how to use the SQL Server SUBSTRING function for extracting text. Includes examples with tables, dynamic extractions and tips.

Jan 8, 2024 · The SUBSTRING function in SQL Server extracts the substring (characters) from the string (character expression) with a given length from the specified position. So, if you need the string part from the specific starting index and with …

To find the index of the specific character, you can use the CHARINDEX(character, column) function where character is the specific character at which you'd like to start the substring (here, @). The argument column is the column from which you'd like to retrieve the substring; it can also be a literal string.

Jun 17, 2024 · The SQL Server SUBSTRING function extracts a substring from a string, starting at a specified position and with an optional length. The SUBSTRING function also works in Azure SQL Database , Azure SQL Data Warehouse , and Parallel Data Warehouse .

Apr 10, 2020 · On SQL Server 2016 and later, we can use STRING_SPLIT here: SELECT id, value AS name FROM yourTable CROSS APPLY STRING_SPLIT(name, ',') ORDER BY id, value;