On Mon, Mar 23, 2015 at 11:34:59AM +0530, Vijay Krishna wrote:
> Hi,
>
> By default the LIKE criteria of MonetDB returns results by matching the
> exact case of the search word (MonetDB Jan 2014 SP1 Mac).
>
> How to make the LIKE criteria to do a case insensitive search by
> default?? 
> (Something like the BINARY keyword that does case sensitive search in
> MySQL??)
>
> I don't wish to add a workaround like "LOWER(column) like LOWER
> (searchword)" here..
>
> Any help much appreciated. Thanks in advance.
>
>
Vijay

MonetDB has ilike for this.
i for ignore case sensitivity.

Niels
>
> Thanks & Regards,
>
> Vijayakrishna.P.
> Mobile : (+91) 9500402305.

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list


--
Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098     sip:4098@sip.cwi.nl
url: https://www.cwi.nl/people/niels    e-mail: Niels.Nes@cwi.nl

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list