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
