MID() Function in sql server

Introduction:

The MID() function is used to extract characters from a text field.

Syntax:

 SELECT MID(column_name,start[,length]) FROM table_name;

Example:

SELECT MID(City,1,4) AS ShortCity
FROM Customers;