OK, I found out that I cannot use a statement like

Select Upper(description) from items

or

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

when the field "description" is a BLOB field
because it produces the error:

Overflow occurred during data type conversion.
Conversion error from string BLOB

I guess this is how the engine works, or is this an error that I can
get around. In my case, the field "description" is a bunch of
historical notes about an inventory item. For my imediate solution,
I will be using the "containing" key word in a select statement, but
if I wanted to do a case insensitive select finding the matching
characters starting from the first character, I guess I'm out of
luck. I haven't looked into a UDF, but I will and it may help me
out. Thanks for all the responses. This is truely a great active
forum.

Wes

--- In firebird-support@yahoogroups.com, "Wes" <wesv@c...> wrote:
> 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?