> hi,
>
> is there any way to tell firebird no use case sensitive search ?
>

You can either use an UPPER function in a UDF, not sure if it's built in to
the latest FB or not, or use the CONTAINING clause for searches. It searches
using a case-insensitive comparison.

Woody (TMW)

[How many of you believe in telekinesis? Raise my hands....]