Long where clause

[#1]

How can I sreate long where clause? Or can I do two clauses in same LOAD statement?

I tried this one, but it doeas not work->

WHERE "kod_system" = 'EU' AND sprak = 'FI' and class= (2,5,8,3,45,98);

[kaushiknsolanki]

Hi,

    It depends where you are using the where clause.

    If you are using where clause with SQL statement then you sould do like this.

    SQL Select Kod_System, Sprak, Class

    From Xyz

    where Kod_System = 'EU' and Sprak = 'FI' and Class in (2,5,8,3,45,98);

    If you are using with  Load statement then you shoudl do like this.

    Load Kod_System, Sprak, Class

    From Xyz

    where Kod_System = 'EU' and Sprak = 'FI' and match(Class,'2','5','8','3','45','98');

Regards,

Kaushik Solanki