<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
You might try:<br>
<br>
<span style="color: rgb(68, 68, 68); font-family: Consolas, 'courier
new'; font-size: 14px; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height: 20px;
orphans: auto; text-align: start; text-indent: 0px;
text-transform: none; white-space: normal; widows: 1;
word-spacing: 0px; -webkit-text-stroke-width: 0px; display: inline
!important; float: none; background-color: rgb(241, 241, 241);">update
"mc-roadsegs" Set "RFROMHN" = "" Where "RFROMHN" IS NULL;<br>
<br>
NULL signify the absence of a value in a field; it not a specific
value; therefore you can't use the "=" operator (as in </span>"RFROMHN"
= "NULL")<br>
<br>
Regards <br>
Bo Victor Thomsen<br>
AestasGIS<br>
Denmark<br>
<br>
<div class="moz-cite-prefix">Den 14-03-2015 kl. 22:57 skrev Chuck
Young:<br>
</div>
<blockquote
cite="mid:CAKckdBRv+WimCKd1j-CVFThMU84yZYt9HBCw1NZKesr17p7LZw@mail.gmail.com"
type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>
<div>
<div>I am trying to eliminate the text "NULL" from a
table. I have imported a set of Tiger road data and
in some of the columns that I need to display the
data itr has "NULL" in the field. If it is Null I
would really like that NOT to show up in the
labeling on the map.<br>
<br>
</div>
I have tried some standard SQL update queries but they
didn't work. <br>
<br>
I tried the following from the QSpatialite form that
appears from within QGIS. <br>
Example:<br>
update "mc-roadsegs" Set "RFROMHN" = "" Where
"RFROMHN" = "NULL";<br>
<br>
</div>
I also tried to construct a query from within the query
builf=der at the top of the Attribute table in Edit
mode.<br>
<br>
</div>
I really need to remove these unwanted valued. It has
been a while since I used SQL on a routine basis so I am a
bit rusty. <br>
<br>
</div>
Any help will be much appreciated!<br>
<br>
</div>
Thanks<br>
<br>
</div>
Chuck<br>
</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>