Substring

Overview

Returns the portion of the specified string starting with the specified character position and no longer than the specified length. If the specified character position exceeds the length of the specified string, the function returns an empty string.

Syntax

Substring(1, 2, 3)

Function Properties

OrdinalTypeDescription
1stringRequiredInitial string value
2numericRequiredCharacter position used to begin substring
3numericMaximum length of substring

Usage

System returns: