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 <[email protected]>
To: [email protected]
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
