To prevent portability issues !=
, !>
and !<
operators should be replaced by the ANSI standard
operators: <>
, <=
or >=
.
Noncompliant code example
SELECT C1 FROM S1TESTMD WHERE BIRTHDATE != 2000
Compliant solution
SELECT C1 FROM S1TESTMD WHERE BIRTHDATE <> 2000