| Subject | Re: [firebird-support] Searching on BLOB data - case sensitive | 
|---|---|
| Author | Ann W. Harrison | 
| Post date | 2005-06-03T18:31:04Z | 
Kevin Day Programming wrote:
because containing is not case sensitive.
Regards,
Ann
            >Upper may work with blobs, but is completely unnecessary in this query
>
> A sure fire way is
> select description
> from items
> where upper(description) containing 'COMPUTER'
because containing is not case sensitive.
Regards,
Ann