tom preston tom preston - 3 months ago 8
SQL Question

Exclamation mark in table.column !=0

Using SQL Server 2008 I have a query which resembles this:

SELECT *
FROM myTable mt
left join otherTable ot on mt.ID = ot.ID
WHERE DateTime > '20160801'
and mt.ID !=0


What is the
!=0
? It looks like it's the same as saying
<> 0
.

I am unable to google this, is this in fact the same? A link to some documentation would be appreciated.

Thanks in advance, TP

Answer

It is exactly the same operator as <>.

See MSDN for reference.

Comments