<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>please try it. it does work! qgis filter is usually accepting all
valid sql queries.</p>
filter: lower("value") similar to '(berlin|london|paris)'<br>
<br>
<a>https://wambachers-osm.website/images/osm/snaps_2017/similar.png</a><br>
<br>
ok, havin problems with hstore, but that's is another question.<br>
<br>
regards<br>
walter<br>
<br>
<div class="moz-cite-prefix">Am 28.07.2017 um 13:31 schrieb "Torben
Keßler":<br>
</div>
<blockquote type="cite"
cite="mid:trinity-b255f094-cf96-4dc5-94f4-68cca0f86d3b-1501241506607@3capp-webde-bs10">
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div>Thanks! Just erased the wildchars to shorten the code.</div>
<div> </div>
<div>I forgot to mention that I'm trying this as a QGIS (v
2.18.7) filter, not in ProstgreSQL. There, I have only
"ilike" as suitable string operator, it seems.</div>
<div> </div>
<div>Best,</div>
<div>Torben</div>
<br>
</div>
</div>
</blockquote>
<br>
</body>
</html>