Garbage after statement

[Anonymous]

It shows "Garbage after statement" when I run:

LOAD @7 as A,
@8 as B
FROM
[E&D final data_JL.xls]
(biff, no labels, table is [Q1 label$])
WHERE @7 is not null;

But it runs OK when I remove "WHERE @7 is not null".

[#2]

Hi

Can u please send me the excel file and and your expected output on any excel file?

thanks

zaman

[#3]

Try adding parenthesis in the WHERE... and using isNull()=0

WHERE (isNull(@7)=0)

[#4]

Hi,

Try below one.

Where Len(@7)>0;

-Sridhar