SUBSTRING

From LongJump Support Wiki
Revision as of 18:38, 7 January 2010 by imported>Evelyn
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

The SUBSTRING function returns the characters in a string that are between the specified start and end character numbers.

Syntax
SUBSTRING(string, start, end)
start should be greater than zero (0)
Return
Text string
Example
SUBSTRING('123 Maple Avenue', 5, 9) = 'Maple'