Filter data

[amit_saini]

Hi Folks,

I need filter help while loading the data. I'm trying below condition to not load the POSID where last digits are '000'

Examples :

C00001000

C00002000

C00003000

C00004000

C00005000

C00006000

where POSID <> right(POSID, 3) like '000'

and second how to select a range KSTAR = 5000000 to 9999999  in where condition.

Thanks,

AS

[effinty2112]

Hi Amit,

Maybe

WHERE NOT WILDMATCH(POSID,'*000')

for the other condition -  KSTAR >= 5000000 AND KSTAR <=9999999.

If you're doing a preceding load from SQL then you can put this clause in the SQL SELECT statement instead:

WHERE KSTAR BETWEEN 5000000 AND 9999999

Good luck

Andrew

[YoussefBelloum]

Or simply:

...

Where right(POSID,3)<>'000';