I'm working on building a new configurator in ERP software Epicor that uses Progress while my old configurator used SQL. Trying to adapt some of these expressions to Progress is proving to be challenging since I don't know the language well yet. I'm particularly interested in the use of the "IN" statement and capturing all of my possibilites in parentheses instead of redundantly writing {Finish} = '74M' OR {Finish} = '75D' OR {Finish} = '75L'.....etc.
Below is an SQL expression that I'd like to rewrite in Progress. [ItemNumber] = 'AWS1296B' AND {Finish} IN ('74M','75D','75L','76G','76W','77D','78') Lastly, if anyone knows of any references that compare and contrasts the various statements between the two languages, it would be helpfull to me. Thanks in advance, Michael |