Null Value

Report Inappropriate Content · ‎2012-05-15

Hi all,

How can i load data without null values

SRS

Jason_Michaelides · ‎2012-05-15

Maybe put WHERE IsNull(YourField)=0 in your load statement?

kaushiknsolanki · ‎2012-05-15

HI,

You can achieve this in this way.

Load * from ABC where not isnull(Field1);

Here Field1 is the field from which you dont want the null data.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2012-05-15

Hi,

Load * from Table_Name where Field_Name <> ' ' ;

Hope it helps

Regards

Ravikumar

Related Topics