Table of contents
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)
