Here is the sql statement but i am getting an error on this can someone help it works fine in MySql

  displaySQL = "SELECT * FROM cinemas, (SQRT(abs("&east1&")*abs("&east2&")+ abs("&north1&")*abs("&north2&"))) AS distance FROM postcodes JOIN cinemas ON cinemas.outcode = postcodes.postcode HAVING distance <= 15000 ORDER BY distance;"

Could you add Response.Write displaySQL into your code, after the above line so that you can see the SQL statement that is being generated. Would then suggest that you try that as a query on the database, away from ASP and see if it works. You may get a clearer idea of what's going wrong with it.

Regards,

Sean Anderson