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)

See Also

Reference

Z (geometry Data Type)

Other Resources

Extended Methods on Geometry Instances