SubString

The Substring() function returns a subset of a text.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a new text that is a subset of text beginning at a position through a number of characters. Returns Invalid expression if one of the parameters is not valid.

Syntax

Substring(text,length)

Substring("Important", 6) => "Import"

Substring(text,start_position,length)

Substring("Important", 2, 4) => "port"

Parameters

Name	Type	Required	Description