HasM (geography Data Type)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance
Returns 1 (true) if a spatial object contains at least one M value; otherwise, it returns 0 (false).
Syntax
.HasM
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 GEOGRAPHY = 'Point(1 1 1 1)'
SELECT @p.HasM
--Returns: 1 (true)
See Also
Extended Methods on Geography Instances
M (geography Data Type)
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for