Number Functions

Right-click in the XPath editor to select number functions used in expressions.

Table 1. Number functions
Name Description
number Converts its argument to a number. Returns NaN if the argument is not a number.
sum Calculates the total of a set of numeric values contained in a node set.
floor Returns the largest integer that is less than or equal to the numeric value of the argument.
ceiling Returns the smallest integer that is greater than or equal to the numeric value of the argument.
round Returns the closest integer to the numeric value of the argument.
add Adds the left and right side together.
subtract Subtracts the right side from the left side.
multiply Multiplies the left and right side.
divide Divides the left side by the value of the right side.
modulus Divides the value of one expression by the value of another and returns the remainder.
Related concepts
XPath Editor

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com