Export (0) Print
Expand All

!= (Not Equal To)

Compares two expressions to determine whether the left expression is not equal to the right expression. The != (Not Equal To) operator is functionally equivalent to the <> operator.

expression!=expression
or
expression <> expression

expression
Any valid expression. Both expressions must have implicitly convertible data types.

true if the left expression is not equal to the right expression; otherwise, false.

The following Entity SQL query uses the != operator to compare two expressions to determine whether the left expression is not equal to the right expression. The query is based on the AdventureWorks Sales Model. To compile and run this query, follow these steps:

  1. Follow the procedure in How to: Execute a Query that Returns StructuralType Results.

  2. Pass the following query as an argument to the ExecuteStructuralTypeQuery method:


-- !=
SELECT VALUE product FROM AdventureWorksEntities.Products
AS product where product.ListPrice != @price
-- <>
SELECT VALUE product FROM AdventureWorksEntities.Products
AS product where product.ListPrice <> @price
    




Build Date:

2012-10-01
Show:
© 2014 Microsoft