Thanks for the prompt reply.

However this is the equivalent C# code

If ([column1]is NULL)

Set [column1]= string.Empty;

If([column1]is NULL)

Set [column1] = 0;

If([column3]is NULL)

Set [column3]= string.Empty;

Switch(([column1])

{

([column1]equals string.Empty:

...