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.