<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1476" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=711281016-19042005><FONT face=Arial size=2>Hello
all,</FONT></SPAN></DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial size=2>I sent out a fairly
dumb question about a week ago and received many helpful responses, and wanted
to thank everyone for that. Now I have another fairly simple (I hope)
question that I cannot find an answer to in the
documentation.</FONT></SPAN></DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=711281016-19042005><FONT face=Arial size=2>If I have a
non-linear linestring, with many points, I know I can find the total distance of
the line with "length(geom)". If I specify a point that lies somewhere
directly on the linestring, is there a function that will determine the length
from the beginning point of the line to the specified point somewhere on that
line? Thanks for the help.</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2></FONT> </DIV>
<DIV align=left><FONT face=Arial size=2>Derek Figg</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>CXT Software,</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>a Connection Technology
Company</FONT></DIV>
<DIV align=left><FONT face=Arial size=2><A
href="http://www.cxtsoftware.com/">www.cxtsoftware.com</A></FONT></DIV>
<DIV align=left><FONT face=Arial size=2>office (602) 265-0195</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>fax (602) 263-0942</FONT></DIV>
<DIV> </DIV></BODY></HTML>