String Functions

Macro Name Returns Description
LIKE One column for each input column Determines whether a text string matches a specified pattern
LOWER One column for each input column Converts string value to lowercase
LTRIM One column for each input column Removes leading space characters from each string value
NUMBER One column for each input column Converts ASCII text strings for times and dates to numeric values
RTRIM One column for each input column Removes trailing space characters from each string value
STRING_CONCAT One column with a value for each row of the shortest input column Concatenates strings from the specified data ranges
SUBSTR or SUBSTRING One column for each input column Returns characters from a string from a starting position
UPPER One column for each input column Converts string value to uppercase
INCLUDE One column for each input column Determines whether a value is included in a specified list.