In case you are getting tired of reading examples from my book (did I mention that I have a textbook you can buy from Amazon?), I thought I would throw a post in here and there that illustrates other aspects of SQL and GIS. A friend recently sent me a file of stream segments, and wanted to determine the sinuosity of each stream segment. You may recall the sinuosity formula as the length of the segment / distance between the start and endpoint of a line. This is essentially a ratio of the theoretical straight line distance between the endpoints and the actual distance along the segment.
Lets suppose we have a vector file named Stream_Sample. Sinuosity is easily calculated with SQL and a few spatial constructs as:
SELECT Length([Geom (I)]) / Distance(StartPoint([Geom (I)]),EndPoint([Geom (I)])) AS ss