SQL- Scalar Functions- MID()

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

Syntax:

SELECT MID(column_name,start,length) FROM table_name

Query:

SELECT MID(EMPname,1,4) AS Employee Name FROM EMPtbl1