CREATE cursor MainC ; (ID_Field I, char_Field c(250)) INSERT INTO MainC VALUES (1,'Mother Father Daughter Son') INSERT INTO MainC VALUES (2,'Mother Daughter Son') INSERT INTO MainC VALUES (3,'Mother Son') INSERT INTO MainC VALUES (4,'Daughter Son') INSERT INTO MainC VALUES (5,'Mother Father Son') INSERT INTO MainC VALUES (6,'Son Daughter Father') INSERT INTO MainC VALUES (7,'Mother Son') INSERT INTO MainC VALUES (8,'Other Word') SELECT 0 CREATE CURSOR KeyWords (Word C(20), IF I) INSERT INTO KeyWords VALUES ('Mother',1) INSERT INTO KeyWords VALUES ('Father',2) INSERT INTO KeyWords VALUES ('Son',3) INSERT INTO KeyWords VALUES ('Daughter',4) lnCount = RECCOUNT() SELECT M.*; FROM MainC M ; INNER JOIN (; SELECT MainC.Id_Field; FROM MainC ; INNER JOIN KeyWords K2 ON MainC.char_Field LIKE '%'+ALLTRIM(K2.Word)+'%'; GROUP BY MainC.Id_Field; HAVING COUNT(*) = lnCount; ) K33; ON M.ID_Field = K33.ID_Field