SUBSTRING function is used in sql to select part of text string in text. This function belongs to the group of text functions – string functions. I created a big summary of T-SQL text functions – you can find it here.

SQL SUBSTRING Syntax

SELECT SUBSTRING(text, <start position of the text character>, <the number of characters to get from the starting point>)

The function has 3 arguments:

• field with text where we select the text
• starting position – numeral position of the character in text from which we will select its part
• number of characters from the starting position

Example of the SUBSTRING Function

DECLARE @TEXT AS VARCHAR(100) = '.gerge.OPGKER/The text we want to get/ FWG--efwER'
SELECT SUBSTRING(@TEXT,15,23)