DECLARE @searchLoc geometry
SET @searchLoc = geometry::Point(@LON, @LAT, @SRID)

SELECT LocationName, <intersectingPoly?>
FROM dbo.LocationTable
WHERE LocationTable.LocGeometry.STIntersects(@searchLoc) = 1