thanks for your help, ILIKE is OK when matching. but when use  ='A' , ='a', in ('a', 'A'),   we don't have a good method 

2012/8/22 Stefan de Konink <stefan@konink.de>
On Wed, 22 Aug 2012, li, xiaohua wrote:

Does  MonetDB   has some parameter to modify the case insensitive option?
when end user write sql,  usually we want to case insensitive.  

If you mean matching, you can use: columnname ILIKE "argument"

Stefan

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users




--
上海云数信息科技有限公司
http://www.cloudybi.com
联系人:李晓华
职务:总经理
手机:18616507502