--- In firebird-support@yahoogroups.com, "skander_sp"
<skander_sp@y...> wrote:

>
> Hello all!
>
> select name
> from customer
> where name containing 'maria';
>
> Ok, Ok... it return all names containing 'maria', but also 'MARIA',
> 'Maria' and other uper lower combinations... all fine.
>

Use the built in UPPER function for comparison.

select name
from customer
where Upper(name) containing Upper('maria');

I am not sure if their are any collation issues to consider though.

Alternatively, I think "like" is case insensitive


select name
from customer
where name like '%maria%';

But I could be wrong on that.

Adam