ike</span> 'name <span class="org-string">"%New%"</span>)))

((103 <span class="org-string">"New Caledonia"</span>) (58 <span class="org-string">"New Zealand"</span>) (108 <span class="org-string">"Papua New Guinea"</span>))

</pre>
</div>

<p>
The sql ilike operator provides the same thing, but on a case insensitive basis. The following is a simple example using the sql ilike operator in s-sql.
</p>
<div class="org-src-container">
<pre class="src src-lisp">(query (<span class="org-builtin">:select</span> '