--- In ib-support@yahoogroups.com, "Michael Vilhelmsen"
<Michael.Vilhelmsen@M...> wrote:

> Hi
>
> I have justed started using blob fields.
> In my program I usually do a .Locate('Field',Value,[]) to locate

a

> specific row.
>
> But this doesn't seem to work with blobs.
>
> Is there somewhere I can find some information on blobs and

searching

> through blobs.
>
> Regards
> Michael

Hi there

If your blob contains text, try something like:

select col1, col2, col_with_blob
from table1
where col_with_blob like '%Firebird rules%'

Regards
Ashley