Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL IS NOT NULL Keyword

Concept visual

SQL IS NOT NULL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

IS NOT NULL Keyword

Is Not Null

The IS NOT NULL

Formula

command is used to test for non - empty values (NOT NULL values).

The following SQL lists all customers with a value in the "Address" field:

Example

SELECT CustomerName, ContactName, Address

FROM Customers

WHERE Address

IS NOT NULL;

SQL IS NOT NULL Keyword

Concept visual

SQL IS NOT NULL Keyword

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

IS NOT NULL Keyword

Is Not Null

The IS NOT NULL

Formula

command is used to test for non - empty values (NOT NULL values).

The following SQL lists all customers with a value in the "Address" field:

Example

SELECT CustomerName, ContactName, Address

FROM Customers

WHERE Address

IS NOT NULL;

SQL IS NOT NULL Keyword

SQL IS NOT NULL Keyword

IS NOT NULL Keyword

Previous

Next

Is Not Null

The IS NOT NULL

Example

FROM Customers

WHERE Address

Previous

Next

SQL IS NOT NULL Keyword

SQL IS NOT NULL Keyword

IS NOT NULL Keyword

Previous

Next

Is Not Null

The IS NOT NULL

Example

FROM Customers

WHERE Address

Previous

Next