SUBSTRING() Function With Table Columns
To use the SUBSTRING() function with table columns we will first create a table “Player_Details“, which has three columns: PlayerId, PlayerName, and City. Since the PlayerId column is designated as the primary key, each row in the table will have a different PlayerId as its identifier.
Ten rows of data are added to the table using the INSERT INTO statement after the table has been created. While the PlayerId column will be automatically generated as a unique identifier for each row, the PlayerName and City columns have values specified for each row.
Query :
CREATE TABLE Player_Details (
PlayerId INT PRIMARY KEY,
PlayerName VARCHAR(50),
City VARCHAR(50)
);
INSERT INTO Player_Details (PlayerId, PlayerName, City)
VALUES
(1,'John', 'New York'),
(2,'Sarah', 'Los Angeles'),
(3,'David', 'Chicago'),
(4,'Emily', 'Houston'),
(5,'Michael', 'Phoenix'),
(6,'Ava', 'Philadelphia'),
(7,'Joshua', 'San Antonio'),
(8,'Sophia', 'San Diego'),
(9,'Daniel', 'Dallas'),
(10,'Olivia', 'San Jose');
Output:
SUBSTRING() Function With Table Columns Example
In this example, we will use the SUBSTRING() function on a table column.
Query
SELECT SUBSTRING(PlayerName, 1, 3) AS ExtractString
FROM Player_Details;
Output
The PlayerName column in the subquery receives the SUBSTRING function, which chooses the first three characters of each name. The outcome of this substring operation is to return the PlayerName column from the subquery in a new column with the alias ExtractString.
SQL Server SUBSTRING() Function
SUBSTRING function in SQL Server is used to extract a substring from a string, starting at a specified position and with an optional length.
It is very useful when you need to extract a specific portion of a string for further processing or analysis.
SQL SUBSTRING function also works in Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse.