I have a database with coordinates in it. I'd like to calculate distance at the SQL level, but the equation for calculating distance requires square root and I'm not sure if I can do this with sqlite. Something like:
SELECT PlaceName, sqrt((PlaceX - 1)^2 - (PlaceY - 3)^2) AS DistFromHome FROM Table WHERE PlaceGroup = 3; What mathematical functions can I do at the sqlite level? I'll preface this with, with stock SQLite (no added components) as it's on a shared web host. -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users