+ (addition)

The addition operator (+) returns the result of adding the two arguments together.

Syntax

X+Y

Input

Argument Type Description
X any numeric type A scalar expression or column expression
Y any numeric type A scalar expression or column expression

Return Value

Returns a numerical value corresponding to the sum of X and Y.

The data type of the result depends on the data type of the arguments.
  • If either X or Y are decimal, the result is decimal.
  • If one argument is big integer and the other is integer, the result is big integer.
  • If both X and Y are integers, the result is integer.

If X and/or Y is N/A, the result is N/A.