Edit

REPLACE (Azure Stream Analytics)

  • Article

Replaces all occurrences of a specified string value with another string value.

Syntax

REPLACE ( stringExpression, stringPattern, stringReplacement )

Arguments

stringExpression

The string expression to be searched.

stringPattern

The substring to be found. If stringPattern is an empty string, then stringExpression is returned.

stringReplacement

The replacement string.

Return Types

Returns NULL if any of the arguments are NULL. Otherwise, returns nvarchar(max).

Examples

SELECT REPLACE(value, pattern, replacement) AS result FROM input
Expression Result
REPLACE('abcde', 'cd', 'xx') 'abxxe'
REPLACE('cdabcd', 'cd', 'x') 'xabx'
REPLACE('cd', 'cd', 'xxx') 'xxx'
REPLACE('abcde', 'gh', 'xx') 'abcde'
REPLACE('abcde', 'cde', '') 'ab'
REPLACE('abcde', '', 'xxx') 'abcde'
REPLACE('', 'cde', 'xxx') ''
REPLACE(NULL, 'cde', 'xxx') null
REPLACE('abcde', NULL, 'xxx') null
REPLACE('abcde', 'cde', NULL) null

See Also