HasZ (geometry DataType)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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

Syntax

  
.HasZ  

Note

To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

Return Types

SQL Server return type: bit

CLR return type: Boolean

Remarks

Examples

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

See Also

Extended Methods on Geometry Instances
Z (geometry Data Type)