IsNull (geometry Data Type)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2008) ![yes](media/yes.png)Azure SQL Database ![no](media/no.png)Azure SQL Data Warehouse ![no](media/no.png)Parallel Data Warehouse

The type of a geometry instance is null. Returns 0 if the instance is not null.

Syntax

.IsNull  

Return Types

SQL Server type: bit

CLR type: SqlBoolean

Remarks

IsNull can be used to test whether a geometry instance is null. This can produce somewhat confusing results, returning 0 if the instance is not null, but null if the instance is null.

This method is primarily used by the SQL Server infrastructure; it is not recommended that you use IsNull to test whether an instance is null.

See Also

Extended Methods on Geometry Instances