<html><head></head><body><div class="ydp2d1771d3yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr" data-setdir="false">Hi Bob, </div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">A correction to my previous statement, SQL does care about capitalization in string literals, so 'alley' <> 'ALLEY'. But you could write:</div><div dir="ltr" data-setdir="false"><span><span style="color: rgb(38, 40, 42); font-family: sans-serif; font-size: 13.3333px;"> "tag_service" is null or "tag_service" not in ('alley', 'drive-through', 'driveway', 'laneway','parking_aisle', 'parking')</span></span> </div><div dir="ltr" data-setdir="false">AS WELL AS:</div><div dir="ltr" data-setdir="false"><span><span style="color: rgb(38, 40, 42); font-family: sans-serif; font-size: 13.3333px;"> "tag_service" IS NULL OR "tag_service" NOT IN ('alley', 'drive-through', 'driveway', 'laneway','parking_aisle', 'parking')</span></span><br></div><div dir="ltr" data-setdir="false">You could also, remove the double quotes from around the field name, and capitalize the field name and have it work:</div><div dir="ltr" data-setdir="false"> <span><span style="color: rgb(38, 40, 42); font-family: sans-serif; font-size: 13.3333px;">TAG_SERVICE is NULL or TAG_SERVICE not IN ('alley', 'drive-through', 'driveway', 'laneway','parking_aisle', 'parking')</span></span></div><div><br></div><div dir="ltr" data-setdir="false">The double quotes are not necessary unless you have a space or other non-alphanumeric character in the field name.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Hope this helps.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">-Thayer</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false"><br></div><div><br></div>
</div><div id="ydp87dd4fabyahoo_quoted_6166648964" class="ydp87dd4fabyahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, July 7, 2021, 10:49:55 AM EDT, Thayer Young <thayeray@yahoo.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp87dd4fabyiv1078730727"><div><div class="ydp87dd4fabyiv1078730727ydp8f4ebd98yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
<div dir="ltr">Hi Bob, </div><div dir="ltr"><br clear="none"></div><div dir="ltr">No, SQL does not care about capitalization, it is used for humans to read each others code. So I neglected to capitalize the OR, making it harder for you to read, but the interpreter should do just fine.</div><div dir="ltr"><br clear="none"></div><div dir="ltr">Python on the other hand cares very much about capitalization and white space. SQL does not care about white space either, so you can put extra spaces, tabs and carriage returns in your code.</div><div dir="ltr"><br clear="none"></div><div dir="ltr">-Thayer</div><div dir="ltr"><br clear="none"></div><div dir="ltr"><br clear="none"></div><div><br clear="none"></div>
</div><div class="ydp87dd4fabyiv1078730727yqt0742826579" id="ydp87dd4fabyiv1078730727yqt47176"><div class="ydp87dd4fabyiv1078730727ydp7fca7775yahoo_quoted" id="ydp87dd4fabyiv1078730727ydp7fca7775yahoo_quoted_5959326123">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, July 7, 2021, 10:26:50 AM EDT, Basques, Bob (CI-StPaul) <bob.basques@ci.stpaul.mn.us> wrote:
</div>
<div><br clear="none"></div>
<div><br clear="none"></div>
<div><div id="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549"><div>
<div class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549WordSection1">
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><b><span style="color:#00B0F0;">Not a Capitalization thing?</span></b></p>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><b><span style="color:#00B0F0;"> </span></b></p>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><b><span style="color:#00B0F0;">Bobb</span></b></p>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><b><span style="color:#00B0F0;"> </span></b></p>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><b><span style="color:#00B0F0;"> </span></b></p>
<div class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549yqt1627531784" id="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549yqt91623"><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt;">
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in;">
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><b>From:</b> Qgis-user <qgis-user-bounces@lists.osgeo.org> <b>
On Behalf Of </b>Thayer Young<br clear="none">
<b>Sent:</b> Wednesday, July 7, 2021 9:23 AM<br clear="none">
<b>To:</b> qgis-user@lists.osgeo.org<br clear="none">
<b>Subject:</b> [Qgis-user] Select by Expression: exclusive (not inclusive)</p>
</div>
</div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"> </p>
<table class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormalTable" border="1" cellpadding="0" style="background:#E2F700;border:solid black 1.0pt;"><tbody><tr><td colspan="1" rowspan="1" style="border:none;padding:.75pt .75pt .75pt .75pt;">
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><strong><span style="font-family:sans-serif;color:#FF3333;">Think Before You Click:
</span></strong><span style="color:#FF3333;">This email originated <strong><span style="font-family:sans-serif;">outside
</span></strong>our organization.</span></p>
</td></tr></tbody></table>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"> </p>
<div>
<div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">As Marco has explained, QGIS expressions are based on SQL which means that if you use a null containing field in a statement the nulls will be excluded from the query results
unless you specifically state that they should be included. So you need to say:</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">"tag_service" IS NULL or "tag_service" NOT IN ('alley', 'drive-through', 'driveway', 'laneway','parking_aisle', 'parking')</span><span style="font-size:10.0pt;font-family:sans-serif;"></span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;">-Thayer</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;"> </span></p>
</div>
</div>
<div id="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549ydpf9e9583byahoo_quoted_6211684278">
<div>
<div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">From: Andrew Hughes <<a shape="rect" href="mailto:ahhughes@gmail.com" rel="nofollow" target="_blank">ahhughes@gmail.com</a>></span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">To:
<a shape="rect" href="mailto:Qgis-user@lists.osgeo.org" rel="nofollow" target="_blank">Qgis-user@lists.osgeo.org</a></span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Subject: [Qgis-user] Select by Expression: exclusive (not inclusive)</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Message-ID:</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> <CAMvYC1Xs=<a shape="rect" href="mailto:YaXj6Os5vfnnNAV_v60TJCQBauT-YgDnuToc6koMw@mail.gmail.com" rel="nofollow" target="_blank">YaXj6Os5vfnnNAV_v60TJCQBauT-YgDnuToc6koMw@mail.gmail.com</a>></span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Content-Type: text/plain; charset="utf-8"</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Hi All,</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">I can't for the life of me figure out why I can't "Select all features that</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">are *NOT* an alley, drive-through, driveway.... "</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">I am trying to use "Select by Expression".</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">The attribute I am trying to filter with is called "tag_service" and has 77</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">distinct values, including NULL.</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">*Q: Why does this expression select nothing?*</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">*"tag_service" NOT IN ('alley', 'drive-through', 'driveway', 'laneway',</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">'parking_aisle', 'parking')*</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Supplementary, the following does select records (but I want the above</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">expression to work):</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">*"tag_service" IS NULL or "tag_service" = "service"*</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Help would be much appreciated,</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Thank you</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;">Andrew</span></p>
</div>
<div>
<p class="ydp87dd4fabyiv1078730727ydp7fca7775yiv2866599549MsoNormal"><span style="font-size:10.0pt;font-family:sans-serif;color:#26282A;"> </span></p>
</div>
</div>
</div>
</div>
</div>
</div></div>
</div>
</div></div></div>
</div>
</div></div></div></div></div>
</div>
</div></body></html>