Null Help

[bhavvibudagam]

Hi Experts,

Can any one please help me on below requirement.

I have two fields called PRODUCT1 and PRODUCT2 contains blank and null values.

I have convert these values into Null Text.

I have tried

NULLASVALUE "PRODUCT1","PRODUCT2";

SET NULLVALUE = 'NULL';

But i am not able to see NULL text in the above fields.

Please help me on this.

Thanks in advance.

[sasiparupudi1]

Load

DATE,

PRODUCT1,

PRODUCT2;

Sql select

p.date,

COALESCE(p.product1,'NULL') AS p.product1

COALESCE(p.product2,'NULL') AS p.product2

from product p where to_Char(p.date,'DD/MM/YYYY') in $(WHEREPART);