This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Be sure to review our Idea Submission Guidelines for more information!
A very useful and common functionhttps://www.w3schools.com/sql/func_sqlserver_coalesce.asp
Return the first non-null value in a list:
Yes, please! Or, at least an IFNULL function (if argument 1 is null, return argument 2)
I find my self using IIF(ISNULL([field1]), [field2], [field1]) all of the time, so COALESCE or IFNULL would be a big time saver!
Thank you for your suggestion, @simonaubert_bd !
a coalesce function would be so useful, i regularly need to merge columns with 6 or 7 nested ifs..
I'd love to see more functions like these.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.