asbinaryzm-geography-data-type.md

title	AsBinaryZM (geography Data Type)
description	AsBinaryZM (geography Data Type)
author	MladjoA
ms.author	mlandzic
ms.date	03/14/2017
ms.service	sql
ms.subservice	t-sql
ms.topic	reference
ms.custom	ignite-2025
f1_keywords	AsBinaryZM AsBinaryZM_TSQL
helpviewer_keywords	AsBinaryZM, geography AsBinaryZM
dev_langs	TSQL
monikerRange	=azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric-sqldb

AsBinaryZM (geography Data Type)

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

Returns the Open Geospatial Consortium (OGC) Well-Known Binary (WKB) representation of a geometry instance augmented with any Z (elevation) and M (measure) values carried by the instance.

Syntax

  
.AsBinaryZM()  

Return Types

[!INCLUDEssNoVersion] return type: varbinary(max)

CLR return type: SqlBytes

Remarks

Examples

DECLARE @g1 GEOGRAPHY = 'Point(1 1 2 3)';  
  
SELECT @g1.STAsBinary();  
-- Returns: 0x0101000000000000000000F03F000000000000F03F  
  
SELECT @g1.AsBinaryZM();  
--Returns: 0x01B90B0000000000000000F03F000000000000F03F00000000000000400000000000000840  

See Also

Extended Methods on Geography Instances
M (geography Data Type)
Z (geography Data Type)