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
Copyright IBM Corporation 2015. All Rights Reserved.