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.-


__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar