>To optimeze this, you need an index on ALLTRIM(RTE_NO), which is not advicabe, an index key must ALWAYS give a fixed length, which alltrim() does not give! A better solution is an index on ADDBS(RTE_NO,10) (adjust 10 if necessary), and this change in the select:
>Select DISTINCT TIME from RZStop where ADDBS(RTE_NO,10) = lcRteNo ...
You meant PADR() right? :-)
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.