Essential Books

Substring

suggest change

Syntax is: SUBSTRING ( string_expression, start, length ). Note that SQL strings are 1-indexed. 

SELECT SUBSTRING('Hello', 1, 2) --returns 'He'
SELECT SUBSTRING('Hello', 3, 3) --returns 'llo'

This is often used in conjunction with the LEN() function to get the last n characters of a string of unknown length. 

DECLARE @str1 VARCHAR(10) = 'Hello', @str2 VARCHAR(10) = 'FooBarBaz';
SELECT SUBSTRING(@str1, LEN(@str1) - 2, 3) --returns 'llo'
SELECT SUBSTRING(@str2, LEN(@str2) - 2, 3) --returns 'Baz'
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

String Functions:
* String Functions
* Concatenate
* Length
* Trim empty spaces
* Upper lower case
* Split
* Replace
* Stuff
* Substring
* REGEXP
* LEFT - RIGHT
* REVERSE
* REPLICATE
* Replace function in sql Select and Update query
* PARSENAME
* INSTR
Table Of Contents