MID() Function

The MID() function is used to extract values from a column. The MID() contain three (3) parameters. The first one is used to select which column to extract, the second one is the starting position, the last one is the number of characters to be extracted. SQL MID() Syntax SELECT MID(column_name,START[,LENGTH]) FROM TABLE_NAME Consider the following table for this exercise Users Firstname Lastname Salary DeptID John Smith 1000 1 Mathew Simon 3000 1 Bill Steve 2200 1 Amanda Rogers 1800 2 Steve Hills 2800 2 Steve jobs 2400 2 bill cosby 700 3 Example # 1