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 |