Filter Records in Script

[#1]

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!

[#2]

Hi,

one way would be with like statement:

...where ITEM_NUMBER like ‘A*’ or ITEM_NUMBER like ‘B*’ ...

regards

[#3]

Thank you for your suggestion - I will give it a try.