On Wed, 22 Aug 2012, Stefan de Konink wrote:
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"
Using single quotes would help: columnname ILIKE 'argument' select kvk, bedrijfsnaam from sys.kvk where bedrijfsnaam ilike 'monetdb b.v.'; +--------------+--------------+ | kvk | bedrijfsnaam | +==============+==============+ | 321351760000 | MonetDB B.V. | +--------------+--------------+ 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/ !DSPAM:1,5034904122132097614656! _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users !DSPAM:1,5034904122132097614656!