Help with update question 1

[MatsHulten]

Hi!

A time ago I took a backup of a table in the form of a simple copy of the table to ensure that the changes I was about to do wouldn't affect the original data.

Now I need to update the new table with data from the original table, where the fields in the new table exsists and are empty. (Contains only spaces or NULL.)

Could anyone give me some hints as how to do this?

-Mats

 

[calahans]

update originaltable
set originaltable.col1 = newtable.col1
from newtable
where originaltable.id=newtable.id
and originaltable.col1 is null
Cal

Remeber: What the large print givith, the small print taketh away...