> STARTING WITH - sensitive, uses index, no wildcards

o.k.

> LIKE - case sensitive, uses index if "NAME%", no index if "%NAME%",
> wilcards allowed

o.k., for completeness I would add:
no index if LIKE ?

> CONTAINING - case insensitive, doesn't use index, no wildcards

o.k., except of blobs.
Because it is not possible to specify collation for blobs,
case insensitivity is only partial (for lower half of character set).

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