jesus martinez wrote:

> hello.
> i want to do something like this:
>
> SELECT *
> FROM mytable
> where field like '%congratulat%'
>
> field is a blob, but the like is retrieving
> data in a case sensitive way.
>
> what do i have to do to set LIKE to search
> in an insensitive search ?
>
> thanks in advance
> j.-
>

Jesus,

try CONTAINING

SELECT *
FROM mytable
where field containing 'congratulat'

Don't forget that this query will run natural (your query with LIKE with wildcard on the beginning too).


see you !


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