Dominic, in a presence of a function you can not know whether it is "the right way around" until you evaluate, hence there is a filter which gives an opportunity to short-circuit. On Tue, Mar 23, 2010 at 12:12 PM, Brooks, Dominic (London)(c) <dbrooks@xxxxxxxxxxxxxxxxxx> wrote: > That just seems to be a typo. > LSC's original post has the range predicates the right way round. > -- Alex Fatkulin, http://afatkulin.blogspot.com http://www.linkedin.com/in/alexfatkulin -- //www.freelists.org/webpage/oracle-l