>I don't understand you. If that condition was in the original SQL Statement, do we want to preserve it or not? I assume that this condition does a rough filtering and then distance filtering is more precise. If this assumption is correct, then we may want to use this 'rough' filtering first to get less records and then apply more precise filtering based on the computed column.
Please, note also that those SQL are to support SQL Server 2005. In SQL Server 2008, with those spatial data types, the SQL for most of those operations get much simpler. So, as I need to support SQL Server 2005, I am using those ones for now. But, once they will move to SQL Server 2008, they will be able to use the other one.