Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What does <> (angle brackets) mean in MS-SQL Server?

Tags:

sql

sql-server

In My Query one place some other developer using <> (angle brackets) What does it mean ?

sb.append(" AND nvl(VoidFlag, 'N') <> 'Y' ");
like image 671
psisodia Avatar asked Nov 08 '13 09:11

psisodia


1 Answers

<> operator means not equal to in MS SQL.

It compares two expressions (a comparison operator). When you compare nonnull expressions, the result is TRUE if the left operand is not equal to the right operand; otherwise, the result is FALSE. If either or both operands are NULL, see the topic SET ANSI_NULLS (Transact-SQL).

See here : Not Equal To

Also check :

1) Not equal <> != operator on NULL 2) Testing for inequality in T-SQL

like image 158
Upendra Chaudhari Avatar answered Oct 05 '22 23:10

Upendra Chaudhari