mvSQL Database Function - SUBSTRING()¶

Summary¶

Pulls out a part of a string based on position in the string and number of characters to take from the string.

Syntax¶

SUBSTRING(<string>, <position>, <length>)

Parameters¶

string¶

The string to evaluate.

position¶

The substring start position.

length¶

The desired length of the substring.

Returns¶

A substring given the parameters.

Examples¶

SUBSTRING('ABCDEF', 3, 2)

Returns

CD