Adrian et al,

>> be aware that FB cannot use an index with the ending & containing
>> searches, so it can be slow. (I am not sure about index usage for
>> starting with searches though)

A> I'm pretty sure that 'starting with' can use an index.

so does LIKE 'A%', unless it's parametric (LIKE ?, where ? is 'A%').

Ciao
--
Nando mailto:nandod@...