Hi,

 

I was wondering if there is a case insensitive version of the IN operator, similar to ILIKE. Or is the IN itself case insensitive? It’s mainly to avoid using nested OR’s and ILIKE’s if a case insensitive IN exists, to make the queries much simpler. Also, I don’t want to use functions like lower as it’s a big data set and the use of functions may make the queries even slower.

 

Please advise.

 

Thank you.

 

Regards,

 

Kevork Vartanian

Technical Solutions Consultant

kevork.vartanian@innotta.com.au | +61 406 776 789 | www.innotta.com.au

 

 

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