> You say there is already a memo type field that supports LIKE ? What is it
> ?
> I read that setting the SUB_TYPE of a blob to text still does not support
> LIKE, was that article incorrect or is there another type I am unaware of ?

Currently you can search contents of blobs by
case sensitive LIKE and STARTING,
case in-sensitive CONTAINING.

Although search does not use indexes, it is pretty fast because
it is processed _after_ other conditions-optimized-by-indexes are applied.

The only problem is that blobs do not support collations -
it means that CONTAINING is in fact case in-sensitive for basic ASCII characters,
but case sensitive for national characters.

Ivan
prenosil@...
http://www.volny.cz/iprenosil/interbase