Another solution would be to filter these words at the server side. I'm trying to construct the SQL using http://www.berezniker.com/display/SQL/Alines+UDF+-+String+Split but don't have enough luck yet.

>My list could get large, maybe 30 words.
>
>Here is a piece of code:
>
>

>getPSString = "SELECT cinbr, itdsc, ittyp FROM amflib6.pstruc" +;
>" Join amflib6.itemasa On amflib6.itemasa.itnbr = amflib6.pstruc.cinbr" +;
>" Where pinbr = '" + testQuery.cdaitx + "'"
>
>=SQLEXEC(testconn, getPSString, 'getPSQuery')
>
>SELECT getPSQuery
>	
>SCAN FOR AT("TOOL", getPSQuery.itdsc) < 1 AND  AT("MO-ISSUE", getPSQuery.itdsc) < 1
>		
>INSERT INTO psCursor(itemid, rellev, partno, descptn, faiid, faistatus) ;
>Values(x, '1', getPSQuery.cinbr, getPSQuery.itdsc, "", "")
>