How to filter data inside list box

[ecabanas]

Hi,

I have a list box with some data, as I show in the picture, but I don't want to see the blank and null values, is it possible to filter them?

Thank's

Eduard

[er_mohit]

in script you have to do it

load

A,B

C,

if(Fimilia<> '',Fimilia) as Fimilia

from

table;

if <Null> also your field value in Familia then

use this

if(Fimilia<> ''and Fimilia<> '<Null>',Fimilia) as Fimilia

hope it helps

[MayilVahanan]

Hi

Try like this

Either: in list box

if(trim(Len(Fimila)) > 0 or Fimila <> '<NULL>', Fimila)

or in load script:

Load

*,

if(trim(Len(Fimila)) > 0 or Fimila <> '<NULL>', Fimila) AS Fimila

from table;

Hope it helps