Do I need a complex select?

[hortensiam]

Hi all!
I need to change to a six spaces seven fields per record (f1, f2,...,f7) if and only if the value of the field is null.
how can i write this stored procedure?
thanks,

 

[DiegoErnesto]

Hi hortensiam;

update <table>
set <field> = '<string>'
where <field> is null

Bye...

 

[hortensiam]

I want only one update statement to modify all fields in a table. I found the solution:
update table set f1 = isnull(f1,&quot; &quot, f2 = isnull(f2,&quot; &quot where condition1
thanks in advance