At 08:44 PM 11/27/2004, phil_hhn wrote:

Containing is not case sensitive. It's optimization is the same
as like with a leading wild card (e.g. like '%abc%'). The difference
is that like is case sensitive.

Like with a fixed argument that does not start with a wild card
(e.g. like 'abc%') uses an index if one is available. That has
been the case since InterBase 6, at least. Like with a parameterized
argument (e.g like ?) will not use an index, even if the argument
passed has no wild cards. That will change in Firebird V2, I think.

Regards,


Ann