At 02:28 PM 9/7/2001 +0300, raptor wrote:

>STARTING WITH - sensitiveORno?, uses index, no wildcards

STARTING WITH, case sensitive, uses index, no wildcards

>LIKE - case sensitive, uses index if "NAME%", no index if "%NAME%", wilcards
>allowed
>CONTAINING - case insensitive, doesn't use index, no wildcards

right. Indexes in InterBase are exact match and 'a' is not the same as 'A',
unless one defines a collation sequence that defines them to be the same.
Thus any indexed lookup will be case sensitive, unless the column has a
character set that has a non-case-sensitive collation.

One could, I guess build all sorts of twiddly index search algorithms
that looked for NAME NAMe NAmE NaME nAME nAMe ... name, but they suffer
from geometric expansion.


Regards,

Ann
www.ibphoenix.com
We have answers.