Help for older versions available.
Page last updated 11 September 2018
Published 20 November 2017
Use ANSI-style NOT_EQUAL operator (<>).
The ‘!=’ symbol for not equal is not part of the SQL language. It is understood but only for the sake of backward-compatibility.
SQL Code Guard
Didn't find what you were looking for?
Tips and how-to guides for Redgate products
Easy to follow video courses
Ask, discuss, and solve questions about Redgate's tools
Events & Friends
Meet us at an event, get sponsored, and join our Friends of Redgate
In-depth articles and opinion from Redgate's technical journal