• I literally just wrote a parameter that I wanted to allow the user to use OR not use, their choice. It was a range parameter for population figures where the user types in the range (non-queried). So, here's the syntax..

    ((A."Population" BETWEEN (:MinPopulation) AND (:MaxPopulation)) OR ((:MinPopulation IS NULL) AND (:MaxPopulation IS NULL)))

    Now, I checked off ALLOW NULL VALUES and the set the default values to NULL and it seems to be working just fine.

    Oh, I'm working out of an Oracle database hence the reason you're seeing ':' instead of '@.'

    Hope this is somewhat helpful

    Mike