The MultiCaseMatch function extends the capability of the SQL CASE statement by supporting matches to multiple criteria in a single row.
When SQL CASE finds a match, it outputs the result and immediately proceeds to the next row without searching for more matches in the current row.
The MultiCaseMatch function iterates through the input data set only once and outputs matches whenever a match occurs. If multiple matches occur for a given input row, the function outputs one output row for each match.
Use the MultiCaseMatch function when the conditions in your CASE statement do not form a mutually exclusive set.