Skip to content

Latest commit

 

History

History
47 lines (35 loc) · 1.65 KB

isnull-geography-data-type.md

File metadata and controls

47 lines (35 loc) · 1.65 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom f1_keywords helpviewer_keywords dev_langs monikerRange
IsNull (geography Data Type)
IsNull (geography Data Type)
MladjoA
mlandzic
03/14/2017
sql
t-sql
reference
ignite-2024
IsNull (geography Data Type)
IsNull method
TSQL
=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

IsNull (geography Data Type)

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance FabricSQLDB]

A property that specifies if the geography instance is null. Returns 'TRUE' if the instance is null; returns 0 if the instance is not null.

Syntax

  
.IsNull  

Return Types

[!INCLUDEssNoVersion] type: bit

CLR type: SqlBoolean

Remarks

IsNull can be used to test whether a geography 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 [!INCLUDEssNoVersion] infrastructure; it is recommended that you use the T-SQL predicate IS NULL to test whether a geography instance is null. For more information on the T-SQL predicate IS NULL, see IS NULL (Transact-SQL).

Examples

See Also

Extended Methods on Geography Instances