Exclamation mark in table.column !=0

Question

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

SELECT *
FROM myTable mt
WHERE 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.

It is the same: https://msdn.microsoft.com/en-us/library/ms188074.aspx — Jens, Aug 29 '16 at 11:53
>>"I am unable to google this". Try `sqlserver unequal` and you are able to Google it — Jens, Aug 29 '16 at 11:55

score 1 · Accepted Answer · answered Aug 29 '16 at 11:53

1

It is exactly the same operator as <>.

See MSDN for reference.

answered Aug 29 '16 at 11:53

Andrey Korneyev

score 1 · Answer 2 · answered Aug 29 '16 at 11:54

1

This is the C convention for "not equal". There is another C convention for "equal" that looks like ==.

answered Aug 29 '16 at 11:54

John Burger

2 Answers2