Definition
The SUBSTRING() function extracts some characters from a string.
Syntax
SUBSTRING(string, start, length)
where string is the string to extract from, start is the start position (the first position in string is 1) and length is the number of characters to extract and must be a positive number. All three are required.
Example(s)
What to use in Custom SQL field:
SUBSTRING([Employee: First Name],2,2)
SUBSTRING('EQUUS',1,1)
Field Outputs:
