hi,

[#1]

my issue issue is I loaded a table , but it has null values or blank spaces in columns , i need to remove them , how can i do ?

can someone suggest me some expression or solution

[pokassov]

Hello

Load

...

from

...

where not isnull(your_field);

[swuehl]

To handle NULL as well as blanks, a common approach is to check against len(trim(FIELD)):

LOAD

     FIELD,

     AnotherFIELD

FROM TABLE

WHERE LEN(TRIM(FIELD));

[#4]

Thanks for the solutions, I will try doing it