Coalesce ( values )
Returns the first non-empty value, similar to the SQL COALESCE function
Be the first to rate this function Log in to vote
Mislav Kos - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
Similar to the SQL COALESCE function, this custom function will return the first non-empty value from the list of values passed in through the parameter.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.