Quick question about consolidating ANDs and ORs in expressions

[stevelord]

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.