Thank you so much Nicklas! it works .
Zia
Nicklas Avén wrote:
Hi
this should do it:
update thetable set thecolumn=100 where thecolumn is null or thecolumn >
100
Hope that helps
Nicklas
tor 2009-03-26 klockan 15:45 -0400 skrev Zia Ahmed:
Hi All,
I have a table where a column (type- numeric) contains several
thousands NULL-values. I want to covert all of these NULL values to
"100" and values those are greater than "100", I want to convert
these values to 100 too. How do I do this? It will be appreciated if
someone help me out to write the query.
Zia
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
