0 Replies Latest reply: Jun 12, 2013 1:13 PM by Steve Lord RSS

    Quick question about consolidating ANDs and ORs in expressions

    Steve Lord

      Is there a way to write lines like this without all the expressions connected by ANDs?


      fieldname>0 AND fieldname<100 AND fieldname<>otherfieldname


      Something like Where(fieldname,>0,<100,<>otherfieldname)?


      I know this expression is wrong, but looking for a function/expression syntax that is more compact than piling up ANDs and ORs because some of the fieldnames are long and/or paranthesis are running amok in my script.