# STEquals (geometry Data Type)

**THIS TOPIC APPLIES TO:**SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse

Returns 1 if a **geometry** instance represents the same point set as another **geometry** instance. Returns 0 if it does not.

## Syntax

```
.STEquals ( other_geometry )
```

## Arguments

*other_geometry*

Is another **geometry** instance to compare against the instance on which `STEquals()`

is invoked.

## Return Types

SQL Server return type: **bit**

CLR return type: **SqlBoolean**

## Remarks

This method always returns null if the spatial reference IDs (SRIDs) of the **geometry** instances do not match.

## Examples

The following example creates two `geometry`

instances with `STGeomFromText()`

that are equal but not trivially equal, and uses `STEquals()`

to test their equality.

```
DECLARE @g geometry
DECLARE @h geometry;
SET @g = geometry::STGeomFromText('LINESTRING(0 2, 2 0, 4 2)', 0);
SET @h = geometry::STGeomFromText('MULTILINESTRING((4 2, 2 0), (0 2, 2 0))', 0);
SELECT @g.STEquals(@h);
```