GEOGRAPHY_CONTAINS
This function takes in two geospatial objects and determines whether the first one completely covers the area of the second.

Syntax
GEOGRAPHY_CONTAINS ( geo1, geo2 )
Arguments
geo1, geo2: any valid geospatial object or WKT string: path, point or polygon.
Return Type
Boolean
Examples
SELECT id, name FROM neighborhoods WHERE GEOGRAPHY_CONTAINS(shape, "POLYGON(...)");