Character String Returning Numeric Values
Function | Description | Examples |
|---|---|---|
INSTR | Searches a string for a sub-string and returns an integer that is the position in the string of the first character of the sub-string. The INTSR and LENGTH functions are mutually exclusive. | Search for 'error' in the string: 'A big system error caused the problem.' This results in 14. |
LENGTH | Returns the number of characters of a character string. The INTSR and LENGTH functions are mutually exclusive. | Length of 'array type' would be 10 |