SQL MID() and SQL-Server SUBSTRING() FUNCTION

SQL MID() and SQL-Server SUBSTRING() Function

MID() – The MID() function is used to return exact text from given text field.
The syntax of MID() for SQL :

SELECT MID(col_name, strat, length) as some col_name FROM Table_Name

 start - starting position of text
 length - length or number of character to return.

In SQL Server we use SUBSTRING() function.
The syntax of SUBSTRING() in SQL Server :

SELECT SUBSTRING(col_name, strat, length) as some col_name FROM Table_Name

Here, we understand MID() and SUBSTRING() function with an example.
We have SQL Table StudentMst with below column.

SELECT * FROM StudentMst

SELECT MID(name, 1, 3) as  Name, MID(city, 1, 3) as  City FROM StudentMst

SELECT SUBSTRING(name, 1, 3) as  Name, SUBSTRING(city, 1, 3) as  City FROM StudentMst