HasZ (geometry DataType)
Returns 1 (true) if a spatial object contains at least one Z value; otherwise, it returns 0 (false).
Syntax
.HasZ()
Return Types
SQL Server return type: bit
CLR return type: Boolean
Examples
DECLARE @p GEOMETRY = 'Point(1 1 1 1)'
SELECT @p.HasZ
--Returns: 1 (true)