Code has been added to clipboard!

Use of SQL MID

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