Suggest an Idea

[vegard_bakke]

I'd love to have an IF-null function, that basically replaces NULL values.

And the clunky:
    If ( IsNull(<big long expression>), 'default', <big long expression> )
could be replaced with:
   IfNull( <big long expression>, 'default') 

Just like: https://www.w3schools.com/sql/func_mysql_ifnull.asp

[andoryuu]

This would make code cleaner and easier to read.  

[Thomas_Spitzer]

Even better would be a function like Alt() with unlimited parameters, that works not only on numbers but also on strings (something like AltNull()). 

[Or]

This could be implemented quite easily by expanding the Alt() function to accept non-numeric inputs, too. We don't even need a new function.

[Patric_Nordstrom]

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea.

Thanks, 

Patric

[Patric_Nordstrom]

The Coalesce() function does that, returns the first non-null value in a list. Can be used like this:

Coalesce( big long expression, default)

Coalesce is not documented but will be in a near future.

Thanks,
Patric