>If I submit a SQL statement like this
>
>select
> description
>from
> items
>where
> description like '%computer%'
>
>Where the field "description" is a BLOB field,
>I find that the search is case sensitive.
>How can I construct a statement to be
>case insensitive. Do I set something in the
>FB engine or construct a different SQL
>statement?

A sure fire way is
select
description
from
items
where
upper(description) containing 'COMPUTER'

or

select
description
from
items
where
upper(description) like '%COMPUTER%'

regards,
Kevin.