CODEWITHSUNDEEP
sqlsql-server
psisodia
psisodia

Reputation: 1177

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

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

sb.append(" AND nvl(VoidFlag, 'N') <> 'Y' ");

Upvotes: 20

Views: 78270

Answers (1)

Upendra Chaudhari
Upendra Chaudhari

Reputation: 6543

<> 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

Upvotes: 30

Related Questions