Hi Hans,

For a quick and cheap solution, you could do something like:-

UPDATE [TableName] SET
[fieldname1] = CASE WHEN [fieldname1] IS NULL THEN 0 ELSE [fieldname1] END,
[fieldname2] = CASE WHEN [fieldname2] IS NULL THEN '' ELSE [fieldname1] END

Regards

Ian.