Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Or simply:
...
Where right(POSID,3)<>'000';