Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Am trying to filter item numbers in the script so item numbers that start with A through Z and items starting with 6DDP and 6DDR display.
Have tried many functions including sample below without any success
SQL SELECT *
FROM "Inventory Master File" WHERE WILDMATCH(ITEM_NUMBER ='A*' or 'B*' or 'C*' or '6DDP*' or '6DDR*');
Thank you in advance for your help!
Hi,
one way would be with like statement:
...where ITEM_NUMBER like ‘A*’ or ITEM_NUMBER like ‘B*’ ...
regards
Thank you for your suggestion - I will give it a try.