On Wed, Dec 29, 2021, 4:34 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
That isn’t how it works. Absence is what is important. Null is not absence. As you showed, if you want nulls to be converted to defaults you can use coalesce.
Thanks sir. It seems unfortunate that there is not a way to indicate absence of the third parameter if I need to set a value for the fourth parameter.
