SET,

Svein Erling Tysvær schrieb:

>
> Rejane,
> Unlike STARTING WITH, LIKE can never use an index,

not quite true.

If you issue a statement like : "LIKE 'ABC%'" Interbase will use an
index (since the optimizer seems to switch statements like these to
STARTING WITH internally).

Luc.