ifnull / coalesce function in OmnisVote upUp2
I do find myself to often write/read:
Calculate lVar as pick(isnull(lVar),lVar,0)
to give a default value to something that can be #NULL and sometime, when the names are long, the code gets harder to read.
Having a function like the SQL ifnull(var, defaultValue) would make the code more readable and compact.
Sorry, there were no replies found.
Log in to reply.