InstanceOf (geometry Data Type)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2008) ![yes](media/yes.png)Azure SQL Database ![no](media/no.png)Azure SQL Data Warehouse ![no](media/no.png)Parallel Data Warehouse

A method that tests if the geometry instance is the same as the specified type. Returns 1 if the type of a geometry instance is the same as the specified type, or if the specified type is an ancestor of the instance type; otherwise, returns 0.

Syntax

  
.InstanceOf (geometry_type )  

Arguments

geometry_type
Is an nvarchar(4000) string specifying one of 15 types exposed in the geometry type hierarchy.

Return Types

SQL Server return type: bit

CLR return type: SqlBoolean

Remarks

The input for the method must be one of the following: Geometry, Point, Curve, LineString, CircularString, CompoundCurve, Surface, Polygon, CurvePolygon, GeometryCollection, MultiSurface, MultiPolygon, MultiCurve, MultiLineString, and MultiPoint. This method throws an ArgumentException if any other strings are used for the input.

Examples

The following example creates a MultiPoint instance and uses InstanceOf() to see if the instance is a GeometryCollection.

DECLARE @g geometry;  
SET @g = geometry::STGeomFromText('MULTIPOINT(0 0, 13.5 2, 7 19)', 0);  
SELECT @g.InstanceOf('GEOMETRYCOLLECTION');  

See Also

Extended Methods on Geometry Instances