Caché MultiValue Basic Reference
Adds two numeric strings.
function adds two numeric values, expressed as either numbers or as strings, and returns the result. Leading plus signs and leading and trailing zeros are ignored. A string is parsed as a number until a non-numeric character is encountered. Thus 7dwarves is parsed as 7. Non-numeric strings and the null string are parsed as 0.
To perform arithmetic operations on numeric strings, use the SADD
, and SDIV
To perform arithmetic operations on floating point numbers, use the FADD
, and FDIV
functions, or use the standard arithmetic operators.
To perform integer division, use the DIV
function. To perform modulo division, use the MOD
To perform arithmetic operations on corresponding elements of dynamic arrays, use the ADDS
, and MODS
To add together the element values within a single dynamic array, use either the SUM
function (for single-level dynamic arrays) or the SUMMATION
function (for multi-level dynamic arrays).
To perform numeric comparison operations, use the SCMP
function, or use the standard comparison operators.
The following examples use the SADD
function to add two numeric strings. All of these examples return 10:
All of the following examples return 7: