How to test if a SQL Server Geography column value is POINT(0 0)?

Question

The following code works, but it woefully slow:

select top 100 FooId
from dbo.Foos
where latitudelongitude.ToString() = 'POINT(0,0)'
order by FooId desc

Is there a better way to determine if a GEOGRAPHY value has the Lat/Long of 0,0 ?

Answer 1

Flip yo test, yo. ;)

declare @g geography = geography::STPointFromText('POINT(0 0)', 4326);

select * 
from dbo.Foos 
where latitudelongitude.STEquals(@g) = 1

Put another way, the query that you originally wrote wasn't SARGable. The one that I wrote is.

Answer 2

You can use the .Lat and .Long to achieve that. Something like this

SELECT TOP 100 FooId
FROM dbo.Foos
WHERE latitudelongitude.Lat = 0 AND latitudelongitude.Long = 0
ORDER BY FooId desc