FIRST_WITH_VALUE Function

Parameters: (String);

Returns: String;

Outputs the first string in a list of input strings that has a value (i.e. not a null or empty string).

If no strings have a value, NULL is returned.

There can be any number of string value parameters.

Example 1: FIRST_WITH_VALUE (‘’,NULL,’Hello World’) = ‘Hello World’

Example 2: FIRST_WITH_VALUE (‘Hello UK’, NULL, ‘Hello World’, NULL) = ‘Hello UK’)

Example 3: FIRST_WITH_VALUE (NULL, NULL) = NULL

Example 4: FIRST_WITH_VALUE (‘Hello England’, ‘Hello World’,’Hello UK’) = ‘Hello England’