---
title: "!= (Not Equal To) (Transact-SQL) | Microsoft Docs"
ms.custom: ""
ms.date: "03/06/2017"
ms.prod: "sql-non-specified"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
f1_keywords: 
  - "!="
  - "Not Equal To"
  - "!=_TSQL"
  - "Not Equal"
  - "Equal"
dev_langs: 
  - "TSQL"
helpviewer_keywords: 
  - "!= (not equal to)"
  - "not equal to operator (!=)"
ms.assetid: f1054809-04f2-4995-9ebd-cb67098e6708
caps.latest.revision: 20
author: "BYHAM"
ms.author: "rickbyh"
manager: "jhubbard"
---
# Not Equal To (Transact SQL) - exclamation
[!INCLUDE[tsql-appliesto-ss2008-all_md](../../includes/tsql-appliesto-ss2008-all-md.md)]

  Tests whether one expression is not equal to another expression (a comparison operator). If either or both operands are NULL, NULL is returned. Functions the same as the [<> (Not Equal To)](../../t-sql/language-elements/not-equal-to-transact-sql-traditional.md) comparison operator.  
  
## See Also  
 [Expressions &#40;Transact-SQL&#41;](../../t-sql/language-elements/expressions-transact-sql.md)   
 [Operators &#40;Transact-SQL&#41;](../../t-sql/language-elements/operators-transact-sql.md)