Caché SQL Reference
- (Negative)
 [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

A unary operator that returns an expression as a negative, numeric value.
Synopsis
-expression
Arguments
expression A numeric expression.
Description
Unary operators perform an operation on only one expression of any of the data types of the numeric data type category.
– (Negative) is a Caché SQL extension.
Examples
The following example returns three numeric fields: the Age column from Sample.Person; the – (Negative) value of the average of Age; and the Age minus the average age:
SELECT Age,
       -(AVG(age)) AS NegAvg,
       Age-AVG(Age) AS AgeRelAvg
FROM Sample.Person
 
See Also
+ (Positive)