<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:16px"><div style="" class=""><span style="" class="">Hi Chuck,</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br style="" class=""><span style="" class=""></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span style="" class="">If you are using MS SQL Server the easiest way to take care of this situation is to use the <a href="https://msdn.microsoft.com/en-us/library/ms184325.aspx">ISNULL function</a>:</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica
Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br style="" class=""><span style="" class=""></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal; margin-left: 40px;"><span style="" class="">update mc-roadsegs<br style="" class="">Set RFROMHN = ISNULL(RFROMHN,'')</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br><span style="" class=""></span></div><div class="yui_3_16_0_6_1426420689132_3" style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span style="" class="">Other implementations
of SQL should have similar functions.</span></div><div class="yui_3_16_0_6_1426420689132_3" style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br><span style="" class=""></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span style="" class="">Glenn Weller<br style="" class=""></span></div><div style="" class=""><br style="" class=""></div> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div style="" class="" dir="ltr"> <hr style="" class="" size="1"> <font style="" class="" size="2"
face="Arial"> <b style="" class=""><span class="" style="font-weight:bold;">From:</span></b> Chuck Young <wylie1066@gmail.com><br style="" class=""> <b style="" class=""><span class="" style="font-weight: bold;">To:</span></b> Qgis-user@lists.osgeo.org <br style="" class=""> <b style="" class=""><span class="" style="font-weight: bold;">Sent:</span></b> Saturday, March 14, 2015 4:57 PM<br style="" class=""> <b style="" class=""><span class="" style="font-weight: bold;">Subject:</span></b> [Qgis-user] SQL to update table<br style="" class=""> </font> </div> <div style="" class=""><br style="" class=""><div style="" class="" id="yiv7212292783"><div style="" class="" dir="ltr"><div style="" class=""><div style="" class=""><div style="" class=""><div style="" class=""><div style="" class=""><div style="" class="">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 style="" class=""><br style="" class=""></div>I have tried some standard SQL update queries but they didn't work. <br style="" class=""><br style="" class="">I tried the following from the QSpatialite form that appears from within QGIS. <br style="" class="">Example:<br style="" class="">update "mc-roadsegs" Set "RFROMHN" = "" Where "RFROMHN" = "NULL";<br style="" class=""><br style="" class=""></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 style="" class=""><br style="" class=""></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 style="" class=""><br style="" class=""></div>Any help will be much appreciated!<br style="" class=""><br style=""
class=""></div>Thanks<br style="" class=""><br style="" class=""></div>Chuck<br style="" class=""></div></div><br style="" class="">_______________________________________________<br style="" class="">Qgis-user mailing list<br style="" class=""><a style="" class="" ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br style="" class=""><a style="" class="" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br style="" class=""><br style="" class=""></div> </div> </div> </div></body></html>