STDisjoint (geography Data Type)
Returns 1 if a geography instance is spatially disjoint from another geography instance. Returns 0 if it is not.
The following example uses STDisjoint() to test two geography instances to see if they are spatially disjoint.
DECLARE @g geography; DECLARE @h geography; SET @g = geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326); SET @h = geography::STGeomFromText('POINT(-122.34900 47.65100)', 4326); SELECT @g.STDisjoint(@h);