SUBSTR

Gets part of a piece of text

Syntax

SUBSTR(value, start)

SUBSTR(value, start, length)

Example

substr('JanFebMarApr',6,3)

Notes

The example would return Mar.  Position 0 would be ‘J’, 1 would be ‘a’.  So position 6 is ‘M’.  Then we count 3 letters from there.