>>>create cursor c_words (Word C(240)) >>>index on Word Tag Word && Might be an overkill? >>> >>>insert into c_words (Word) values ('TOOL') >>>insert into c_words (Word) values ('MO-ISSUE') >>> >>>INSERT INTO psCursor(itemid, rellev, partno, descptn) ; >>>Select 'x','1',cinbr,itdsc From getPSQuery Where itdsc Not in (select Word from C_Words)>>>
>Select getPSQuery >Scan > select badwordcursor > locate for AT(badword,getPSQuery.itdsc)>0 > if found() > loop > endif > INSERT INTO psCursor(itemid, rellev, partno, descptn) ; > values('x','1',getPSQuery.cinbr,getPSQuery.itdsc) >Endscan >Note, that you named it BadWordCursor and I just used milder Unwanted <g>