2 Replies Latest reply: Sep 20, 2012 4:00 PM by mmccooey RSS

    Filter Records in Script

      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!