Nulls from DB

[soniasweety]

Hi all,

i am getting nulls from Database only

but i want to exclude nulls from DB while loading itself  how can i do this in script?  you can see in image with empty spaces i  dont want that

Thanks

Sony

[trdandamudi]

Give a try as below:

WHERE Len(Trim(Deal_Type)) > 0

[andrei_delta]

Hi,

you can use also:

Load

...

From/Resident

Where not isnull(Field);