Four new built-in functions in Azure Stream Analytics address common scenarios:
- REPLACE replaces all occurrences of a specified string value within another string value.
- COALESCE evaluates a list of arguments and returns the value of the first expression that is not NULL.
- ROUND returns a numeric value rounded to the specified length or precision.
- CROSS JOIN joins reference data with an event stream.