Hi Wes,

Wes 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?
>
>
>

select
description
from
items
where
description containing 'computer'

note this query will not use an index (but your with like '%something%'
won't use too)

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.5.0 - Release Date: 02/06/2005