<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Thank you so much Nicklas! it works .<br>
<br>
Zia<br>
<br>
Nicklas Avén wrote:
<blockquote cite="mid:1238097224.8604.2.camel@ubuntu64" type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>