On 23 Aug 2009, at 5:00pm, P Kishor wrote: > WHERE a*x - y + c = 0
Here's the problem. This works only when the equation is exact. Which under normal circumstances means that all the numbers fit neatly with some imaginary integer formula. This isn't how real life works, especially when you've correctly noted that your measured heights weren't measured at exactly regular intervals. You're going to have to do some proper programming. For example, how to interpolate the height at an arbitrary position when you have a collection of heights measured nearby. There's no easy solution and you certainly can't do the majority of the work inside a SQL query. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users