Add null value

amiroh81 — Mon, 08 Sep 2014 06:45:40 GMT

Hello everyone,

There is QVD which contains four columns,

I would like to add a column where there are values equal to NULL.

How do I do this?

Of course I can add a new column with a value other than NULL.

Thanks in advance everyone.

Re: Add null value

sushil353 — Mon, 08 Sep 2014 06:51:09 GMT

Hi,

Try something like

if(isnull(coulmn),'Y',coulmn)

HTH

Sushil