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