Oh, Borislav, you may regret offering your help. I thought you had contributed to the thread but I misread replies to me. I refer you to my message #997258.

Title: Is it possible to speed this loop and/or SQL up?

As it is it's still taking forever. I've now tried the following, since Tore's latest reply/advice, but no joy - only c. 37 records in 1 minute:

Select DISTINCT TIME from	RZStop ;
  where 	PADR( RZStop.RTE_NO, 6) + "A" + RZStop.DIRECTN = lcCompKey ;
  and	STR( RZStop.Number, 3)			 = lcNumber ; 
  and	PADR( RZStop.Stop, 8)			 = lcStopNo ;
  and	PADR( RZStop.County, 2)			 = lcCounty ;
  and	not EMPTY( RZStop.TIME) ;
 	to SCREEN NOCONSOLE && Find any time value for this particular stop across all other sequences
If _TALLY = 0		 && no hits on this stop # - i.e. all Time values empty
    ...

Cheers

Terry



>>>It's always better if somebody else has a problem :o))))))
>>
>>Hell, you know I'm still struggling with this SQL thing with my Routes. :-(
>
>What SQL thing? May be I could help?