|< < 52 > >|

Unknown values and NULL

Comparison operators

However ...

• It is occasionally useful to know that you have a NULL.

• I.e., compare x to NULL and get true if x is NULL, false if it isn't.

• But using any comparison operator with NULL yields NULL.

SQL provides special NULL comparison operators:

• is null
• is not null

|< < 52 > >|