[Qgis-user] SQL to update table

[Glenn Weller]

Hi Chuck,

If you are using MS SQL Server the easiest way to take care of this situation is to use the ISNULL function:

update mc-roadsegs
Set RFROMHN = ISNULL(RFROMHN,'')

Other implementations of SQL should have similar functions.

Glenn Weller



________________________________
 From: Chuck Young <wylie1066 at gmail.com>
To: Qgis-user at lists.osgeo.org 
Sent: Saturday, March 14, 2015 4:57 PM
Subject: [Qgis-user] SQL to update table
 


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.

I have tried some standard SQL update queries but they didn't work.  

I tried the following from the QSpatialite form that appears from within QGIS. 
Example:
update "mc-roadsegs" Set "RFROMHN" = "" Where "RFROMHN" = "NULL";

I also tried to construct a query from within the query builf=der at the top of the Attribute table in Edit mode.

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.  

Any help will be much appreciated!

Thanks

Chuck

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150315/41ab46ee/attachment.html>