Subject Re: [IBO] Searching into Formatted memo fields
Author Helen Borrie
At 11:30 AM 15/11/2004 +0200, you wrote:

> Hi all
> I have a TIB_RichEdit connected to a memo field.
> I want to use a Query to search in this memo field, but everytime I use
>words like 'font', 'size', 'color' as search criterias I have a result set
>even if I don't have those words in the field value. Is there a way I can
>search into Formatted text by using a query by ignoring the text format
From the database service point of view, no. To the database, a blob is
just a long stream of bytes. Searching a blob containing text is simply a
matter of applying search criteria to the stream, starting at byte 1 and
end at byte n.

So, CONTAINING 'color' OR CONTAINING 'font' is certain to return a result
from an RTF file.

If you had a UDF that could process the blob and a regular expression, or
one that acted a bit like a blob filter and stripped out tags and returned
a result that the engine could interpret as true or false, then it would be
possible to engineer a "stripped search". You can probably even find the
code to do this in the implementation of the PlainText property of TRichEdit.