- (Negative) (Entity SQL)
Returns the negative of the value of a numeric expression.
- expression
Arguments
- expression
Any valid expression of any one of the numeric data types.
Result Types
The data type of expression.
Remarks
If expression is an unsigned type, the result type will be the signed type that most closely relates to the type of expression. For example, if expression is of type Byte, a value of type Int16 will be returned.
Example
The following Entity SQL query uses the - arithmetic operator to return the negative of the value of a numeric expression. The query is based on the AdventureWorks Sales Model. To compile and run this query, follow these steps:
Follow the procedure in How to: Execute a Query that Returns StructuralType Results (EntityClient).
Pass the following query as an argument to the
ExecuteStructuralTypeQuery
method:
SELECT VALUE product FROM AdventureWorksEntities.Product
AS product where product.ListPrice = -(-125)
The output is shown below:
ProductID: 842
Name: Touring-Panniers, Large
ProductNumber: PA-T100
MakeFlag: False
...