*and Left (RecordType,2) # 'AP' and NOT RecordType LIKE 'AP%'>The following is very slow, presumably because of my use of IN
Select * From KTrackTagDetail ; > where (Seqno In (Select Seqno From C_Kits) ; > or SeqnoFG In (Select Seqno From C_Kits)) ; > and Left (RecordType,2) # 'AP' ; > into Cursor C_Detail>So, how can I speed this up?