Exclude garbade Data

[mario-sarkis]

Dear all

here is my example and hope that you can help:

I have a field PeridoDate number form:

i.e.: I have the below field (PeriodDate)

PeriodDate:

       42005

       42006

       42007

       42008

2|Ce

40|dsad

dasf.....

..

I need to exclude everything note date how can I do it ?

Hope that you can help.

Thanks in Advance

Mario

[sunny_talwar]

May be like this if everything else is text

LOAD PeriodDate

FROM ...

Where IsNum(PeriodDate);

[Anonymous]

where isnum(num#(PeriodDate));

when using non numerical field as input...

[MarcoWedel]

or just

Where PeriodDate;

as all numerical values not qual 0 evaluate as true.

regards

Marco