Substring In SQL

Chapter: SQL Commands Last Updated: 27-11-2019 16:59:45 UTC


            /* ............... START ............... */
SELECT SUBSTRING('SQL Substring example', 1, 3) result;
(1 row affected)

SELECT SUBSTRING('SQL Substring example', 5, 9) result;
(1 row affected)
SELECT SUBSTRING(ClientName, 2, 5) AS Name
FROM Client;  
/* This will extract the substring from the text in a column 
ClientName (start at position 2, extract 5 characters) */
SELECT SUBSTRING("SQL Tutorial", -5, 5) AS ExtractString;

/* Extract a substring from a string (start from the end, 
at position -5, extract 5 characters) */
                /* ............... END ............... */


  • The SUBSTRING() function in SQL is used to extracts characters from a string.
  • Syntax : SUBSTRING(string, start_index, length_of_character)
  • Above Syntax string parameter is the string passed for extraction, start_index is the index where the extraction starts length_of_character is the length of characters to extract from string.
  • start index of extraction for all string in SQL starting index is always 1.
  • If you pass negative number in length parameter it will throw and error.
  • For more information please refer the program section.
Similar Programs Chapter Last Updated
SQL Query To List All Databases SQL Commands 17-04-2023
SQL Query To Find Duplicate Records SQL Commands 17-04-2023
How To Create Procedure In SQL SQL Commands 24-03-2023
Group By In SQL SQL Commands 12-11-2020
SQL SELECT Statement SQL Commands 16-03-2018