Mid - script and chart function

This function returns the string starting at character n1 with the length of n2 characters. If n2 is omitted, the function returns the rightmost part of the string starting at character n1. The positions in the string are numbered from 1 and up.

Syntax:  

Mid(s, n1[, n2 ])

 

Examples and results:

For a more complicated example, see the index function.

Example	Result
Mid('abcdef',3 )	Returns 'cdef'
Mid('abcdef',3, 2 )	Returns 'cd'
Mid( Date,3 ) where Date = 970714	Returns '0714'
Mid( Date,3,2 ) where Date = 970714	Returns '07'