Dear Fabian,<div><br></div><div>I use single quotes now and it works. Thanks.</div><div><br></div><div>Do you have any idea wrt the other queries?</div><div><br></div><div>Regards</div><div>Freddy<br><br><div class="gmail_quote">

2012/3/6 Fabian Groffen <span dir="ltr">&lt;<a href="mailto:Fabian.Groffen@cwi.nl">Fabian.Groffen@cwi.nl</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

<div class="im">On 06-03-2012 14:31:37 +0100, Freddy Priyatna wrote:<br>
&gt; 3) SELECT nr, label<br>
&gt;<br>
&gt;     FROM product<br>
&gt;<br>
&gt;     WHERE label like &quot;%countries%&quot;;<br>
&gt;<br>
&gt; It seems that MonetDB doesn&#39;t support regex.<br>
<br>
</div>Use used double quotes by mistake.<br>
<br>------------------------------------------------------------------------------<br>
Keep Your Developer Skills Current with LearnDevNow!<br>
The most comprehensive online learning library for Microsoft developers<br>
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,<br>
Metro Style Apps, more. Free future releases when you subscribe now!<br>
<a href="http://p.sf.net/sfu/learndevnow-d2d" target="_blank">http://p.sf.net/sfu/learndevnow-d2d</a><br>_______________________________________________<br>
MonetDB-users mailing list<br>
<a href="mailto:MonetDB-users@lists.sourceforge.net">MonetDB-users@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/monetdb-users" target="_blank">https://lists.sourceforge.net/lists/listinfo/monetdb-users</a><br>
<br></blockquote></div><br></div>