Substring

The function of “SubString” is to get a substring of a field by indicating the start and end position from the beginning of the field.

Syntax

: substring(field_name, int start, int end)

Example

: substring(field_name, 0, 4)