Menage null value

[#1]

Hello,

i need to menage a null in where statement:

load

...

Where Amount <> Null() ;

if I use this statement do ot work. Infact in the Amount cel I found :

"-"

also if I write <> '-'

do not work ...

thanks

Regards

Slash

[#2]

hi,

probably you should use

load

...

Where Amount ;

thanks

[#3]

it doesn't work..

Look at this sample:

A	number	date
Paul	20490	13/11/2009
Paul	20492	13/11/2009
Paul	20494	13/11/2009
Paul	-	13/11/2009

I need to eliminate this row:

Paul	-	13/11/2009

by Where statement

thanks

[#4]

Hi

You can try this :

LOAD

.......

WHERE len( Amount ) > 0 ;

Regards

Benoît

[tizianacaem]

Hi,

try with the instruction IsNull, that returns the value -1 if the filed is null.

So if you have to show the records that have Amount not null, you can use:

if (isNull(Amount)<>-1, .....

hope to be useful

[#6]

hi,

pls see the attached application and the excel file.

probably this is what u want

thanks

[#7]

hi,

pls see the attached application and the excel file.

probably this is what u want

thanks

[#8]

hi,

this is the excel file

tahnks