Caché MultiValue Basic Reference
SADD
[Back] [Next]
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Adds two numeric strings.
Synopsis
SADD(numstr1,numstr2)
Arguments
numstr An expression that resolves to a number or numeric string.
Description
The SADD 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.
Arithmetic Operations
Examples
The following examples use the SADD function to add two numeric strings. All of these examples return 10:
PRINT SADD(7,3)
PRINT SADD("7","3")
PRINT SADD("+7.00","003")
PRINT SADD("7dwarves","3wishes")
All of the following examples return 7:
PRINT SADD(7,0)
PRINT SADD("7","")
PRINT SADD("7","three")
See Also