| FORMAT |
One column for each input column |
Provides output formatting control for both numbers and strings
(such as 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 |
| 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 |
| POSITION |
One column for each input column |
Returns the starting position of a pattern in a text string |
| 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 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_PROPER |
One column for each input column |
Converts each string value by changing the first letter or
any letter that follows a white space character or symbol (other than
underscore) into uppercase, and all other characters into lowercase |
| 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 n characters of each string in the
specified data range |
| 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 |