MID Returns a string of characters from the middle of a text string, given a starting position and length.
MID(text, start_num, num_chars)
text – The text string from which you want to extract the characters, or a column that contains text.
start_num – The position of the first character you want to extract. Positions start at 1.
num_chars – The number of characters to return.
A string of text of the specified length.