SUBSTRING

Description

Returns part of a string field.

Syntax

SUBSTRING(string, start_index, stop_index)

Arguments

  string - string expression

  start_index - integer indicating start of the substring.

  stop_index - integer indicating the index of the character following the last character of the substring.

Examples

SUBSTRING('California',4,7) returns 'for'.

Return value datatype

String

Impact of null value

If any (or all) inputs are null, returns null.