Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL IS NULL Keyword

Concept visual

SQL IS NULL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

IS NULL Keyword

Is Null

The IS NULL

command is used to test for empty values (NULL values). The following SQL lists all customers with a NULL value in the "Address" field:

Example

SELECT CustomerName, ContactName, Address

FROM Customers

WHERE Address

IS NULL;

Note:

A NULL value is different from a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation!

Tip:

Always use IS NULL to look for NULL values.

SQL IS NULL Keyword

Concept visual

SQL IS NULL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

IS NULL Keyword

Is Null

The IS NULL

command is used to test for empty values (NULL values). The following SQL lists all customers with a NULL value in the "Address" field:

Example

SELECT CustomerName, ContactName, Address

FROM Customers

WHERE Address

IS NULL;

Note:

A NULL value is different from a zero value or a field that contains spaces. A field with a NULL value is one that has been left blank during record creation!

Tip:

Always use IS NULL to look for NULL values.

SQL IS NULL Keyword

SQL IS NULL Keyword

IS NULL Keyword

Previous

Next

Is Null

The IS NULL

Example

FROM Customers

WHERE Address

Note:

Tip:

Previous

Next

SQL IS NULL Keyword

SQL IS NULL Keyword

IS NULL Keyword

Previous

Next

Is Null

The IS NULL

Example

FROM Customers

WHERE Address

Note:

Tip:

Previous

Next