>>>>Steven,
>>>>
>>>>Similar to Edward but with the possibility of adding any large number of words:
>>>>
>>>>

>>>>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)

>>>>
>>>
>>>These two solutions would not work. We're looking for a partial match, e.g. a small word inside the big description.
>>
>>I would prefer to get some response firstly, but anyway
>>

>>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>

Bad manners. I used to post on anonymous boards, they are so rude you wouldn't believe.