Antw: [SQL] Selecting empty columns

[Gerhard Dieringer]

>>> Hans-Jürgen Schönig <[EMAIL PROTECTED]> 28.11.2000  12.39 Uhr >>>
> How can I retrieve empty columns from a table?
> The affected column is int4, some row do have values, others are empty -
> how can those empty ones be retrieved and updated to 0
>
>    Hans

try:
update tablename set columnname=0 where columnname is null;

Gerhard