Description

Returns a specified section of a string

Syntax

MID(s1, n2[, n3])

·        s1: a string

·        n2: starting character

·        n3: number of characters; returns rest of string if NULL or not provided

Example

MID(“Mañana”, 3, 2)       ® “ña”

MID(“Mañana”, 3)                 ( “ñana”