hasz-geography-data-type.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
HasZ (geography Data Type)	HasZ (geography Data Type)	MladjoA	mlandzic	05/04/2017	sql	t-sql	reference	ignite-2024	HasZ HasZ_TSQL	HasZ geography	TSQL	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

HasZ (geography Data Type)

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

Returns 1 (true) if a spatial object contains at least one Z value; otherwise, it returns 0 (false).

Syntax

  
.HasZ  

Return Types

[!INCLUDEssNoVersion] return type: bit

CLR return type: Boolean

Remarks

Examples

DECLARE @p GEOGRAPHY = 'Point(1 1 1 1)'  
SELECT @p.HasZ   
--Returns: 1 (true)  

See Also

Extended Methods on Geography Instances
Z (geography Data Type)