String Functions

Macro Name	Returns	Function
DISTINCT	One column for each input column
FORMAT	One column for each input column	Provides output formatting control for both numbers and strings (for example, output width, alignment, numeric precision, decimal point symbol, grouping symbol, and so on). Returns the formatted output string.
LIKE	One column for each input column	Determines whether a text string matches a specified pattern
NUMBER	One column for each input column	Converts ASCII text strings for times and dates to numerical values
POSITION	One column for each input column	Returns the starting position of a pattern in a text string
STRING_CONCAT	One column with a value for each row of the shortest input column	Concatenates text strings from the specified data ranges
STRING_HEAD	One column for each input column	Returns the first ncharacters of each string in the specified data range
STRING_LENGTH	One column for each input column	Returns the length of each string in the specified data range
STRING_SEG	One column for each input column	Returns the string segment between two specified indexes
STRING_TAIL	One column for each input column	Returns the last ncharacters of each string in the specified data range
SUBSTR	One column for each input column	Returns characters from a string from a starting position
SUBSTRING	One column for each input column	Returns characters from a string from a starting position