Hello look to standard, please. SQL/MM has part - full text.
SELECT docno FROM information WHERE document.CONTAINS ('STEMMED FORM OF "standard" IN SAME PARAGRAPH AS SOUNDS LIKE "sequel"') = 1 it's little bit baroque, It's sample of method. So,it can be: SELECT .. FROM x.contains(y); It's well readable and elegant too. Regards Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly