What is SQL SUBSTRING?
The SQL Substring feature is a function that enables parts of strings to be accessed.
For example, the function SUBSTRING('212-555-1234', 9 , 4) returns:
It returns 4 characters starting in position 9.
Why Use SQL SUBSTRING?
Substring is useful when accessing a column that consists of meaningful subcomponents, such as a telephone number that contains area code, prefix and phone number body.
How To Use SQL SUBSTRING
SQL SUBSTRING is used as follows.
SQL SUBSTRING Syntax
SQL SUBSTRING Example
This example returns three characters of the region_name column starting in position 2.
Here are the contents of the table:
This SQL Statement with SUBSTRING is executed:
Here is the result.