String functions manipulate data to conform to a certain format. The string functions are summarized in the table below.
Note | If the destination of the data is a field with a specific format, keep in mind the system will execute any DAL processing before it applies the format specified in the field’s format mask. |
Function |
Result |
Rounds numbers based on Banker’s rounding. Values below 0.5 go down, values above 0.5 go up, and values of exactly 0.5 go to the nearest even number. |
|
Finds and returns the position of a character (or string of characters) within another string of characters. |
|
Converts an integer into a single character. |
|
Converts a single character into an integer value. |
|
Searches for a string in a list of a strings. |
|
CPSTR | Convert a string constant, or any value from a string variable, to a specific codepage number. |
Removes characters from a string at a specified position and returns the result. |
|
Removes formatting from a string field and returns the result. |
|
Finds the position of a substring within a string and returns the result. |
|
Formats a string field and returns the result. |
|
Converts a number into a string of words and returns the result (in French). |
|
Inserts a substring into a string at a specified position and returns the result. |
|
Returns a string center justified. |
|
Returns a string left justified. |
|
Returns a string right justified. |
|
Returns a specified number of left most characters. |
|
Returns the current length of the string. |
|
Searches character string lists and returns the ordinal position (integer) of the first string in the second parameter that matches any of the strings in the first parameter. |
|
Converts all characters to lowercase and returns the result. |
|
Retrieves a string that contains a new line character sequence. |
|
Converts a number into a string of words and returns the result (in English). |
|
Adds trailing spaces or characters and returns the result. |
|
Counts the indexed components within the formatted text |
|
Returns the indexed components from the formatted text. |
|
Returns a specified number of right most characters. |
|
Returns a number rounded to the nearest specified decimal point. |
|
Compares two strings, considering case. |
|
Returns a substring from a string at a specified position. |
|
Removes end spaces and returns the result. |
|
Converts all characters to uppercase and returns the result. |
© Copyright 2014, Oracle and/or its affiliates. All rights reserved. Legal notices.