InstanceOf (geography Data Type)

Applies to: yesSQL Server (all supported versions) YesAzure SQL Database

Tests if the geography instance is the same as the specified type.


.InstanceOf ( 'geography_type')  


To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.


The nvarchar(4000) string specifying one of 16 types exposed in the geography type hierarchy.

Return Types

SQL Server return type: bit

CLR return type: SqlBoolean


Returns 1 if the type of a geography instance is the same as the specified type, or if the specified type is an ancestor of the instance type; otherwise, returns 0.

This geography data type method supports FullGlobe instances or spatial instances that are larger than a hemisphere.

The input for the method must be one of these types: Geometry, Point, Curve, LineString, CircularString, Surface, Polygon, CurvePolygon, GeometryCollection, MultiSurface, MultiPolygon, MultiCurve, MultiLineString, MultiPoint, or FullGlobe.

This method throws an ArgumentException if you use any other strings for the input.

This method isn't precise.


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

DECLARE @g geography;  
SET @g = geography::STGeomFromText('MULTIPOINT(-122.360 47.656, -122.343 47.656)', 4326);  

See Also

Extended Methods on Geography Instances