is there any difference between: "not variable is null" and "variable is not null"?

Question

I'm a newbie in SQL and I'm wondering if there is any difference between:

not variable is null

and

variable is not null

Is the same as `! a==b` and `a!=b` but I would prefer the last one. Wouldn't you? — juergen d, Jan 24 '17 at 09:19
I'm just trying to understand one script and this kind of syntax i've never seen before. Thanks for the reply. I would prefer the second one because its visually more understandable — Edvards Veļa, Jan 24 '17 at 09:26
The difference is that `not variable is null` is harder to read and reason about for the developer, while `variable is not null` sounds natural. — SWeko, Jan 24 '17 at 09:33
Check this question http://stackoverflow.com/questions/41504329/what-is-the-difference-between-not-condition-and-not-in-oracle-and-ms-sql-serv/41504527#41504527 — Pரதீப், Jan 24 '17 at 09:39

score 2 · Accepted Answer · answered Jan 24 '17 at 09:35

2

Practically there is NO Difference in both terms. Both of them refers to Nullability of the Variable.

If there is any difference then it's simplicity in the reading.

answered Jan 24 '17 at 09:35

Vikrant

1 Answers1