<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Phil,<br>
<br>
In addition to COALESCE I'd like to promote the use of the function
<b>CONCAT()</b> which treats NULL values as empty strings (it was
changed recently, it's probably since 2.10) what makes it very
handy.<br>
<br>
Example:<br>
<br>
NULL || "hello" -> NULL<br>
<br>
vs.<br>
<br>
CONCAT( NULL , "hello") -> "hello<br>
<br>
vs.<br>
<br>
COALESCE( NULL, "" ) || "hello" -> "hello"<br>
<br>
Cheers,<br>
Matthias<br>
<br>
<div class="moz-cite-prefix">On 09/20/2015 09:54 AM, Phil (The Geek)
Wyatt wrote:<br>
</div>
<blockquote
cite="mid:005301d0f379$8ca06a60$a5e13f20$@wyatt-family.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Hi Folks,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am working with LIST Address Points data
from <a class="moz-txt-link-freetext" href="http://listdata.thelist.tas.gov.au/opendata/">http://listdata.thelist.tas.gov.au/opendata/</a>
(Specifically Clarence Municipality) and I need to concatenate
into one field the full address of each location. I am
struggling to figure out how to do it when there are fields
for unit numbers, building names, numbers to and from etc.
Many of the fields are also NULL so clearly I want those
fields disregarded.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can someone give me a quick heads up on how
to NOT add the data from a field that has NULL?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Chances are I will be doing this regularly
so I am keen to document the required expressions for others
to use as well.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU">Cheers
- Phil<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU">Volunteer
Mapper - <a moz-do-not-send="true"
href="http://www.redcross.org.au/volunteering.aspx"><span
style="color:windowtext;text-decoration:none">Red Cross</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>