Null Handling

[#1]

Hi All,

I have a column in excel with some white spaces present in some of the field values.

When I use isnull function, then it considers, white spaces as also not null.

Can we use some function which would also treat only white spaces entered in some of the field values as null?

Thanks,

Asma

[giakoum]

use isnull together with trim

if(isnull(trim(yourfield....

[buzzy996]

may be,tey tis way..

if(count(urfield)>0,urfield,isnull())

sory,use len instituted of count.

[sunny_talwar]

or you can try this as well

If(Len(Trim(yourField)) <> 0,....

and if you are using it in where clause, then like this:

Where Len(Trim(yourField)) <> 0;

[jonathandienst]

Check the length, as the length of a null is also 0. So instead of isnull:

     if(len(field) > 0, ....)

If the field could contain blanks, then

     if(len(trim(field)) > 0, ....)