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

NameTypeRequiredDescription

text

text

☑️

a text

start_position

numeric

(optional) the position to start from

length

numeric

☑️

the number of characters to take from text

Last updated