>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
>
Why would you want to replace the fieldname2 with the value from the fieldname1? <s>
--sb--