MID function is used to extract characters from a text field
SQL Syntax MID
'Column' is the column where you want to extract data from its value.
'Home' is the position from which to start extracting.
'Length' is the number of characters to be extracted. Failure to specify, will catch up to the end of the text field.
Example SQL MID
Given the following table 'orders'
If we remove the first 3 characters of the values in column 'customer':
The results will be: