REVERSE (SSIS Expression)

Applies to: yesSQL Server (all supported versions) yes SSIS Integration Runtime in Azure Data Factory

Returns a character expression in reverse order.

Syntax

  
REVERSE(character_expression)  

Arguments

character_expression
Is a character expression to be reversed.

Result Types

DT_WSTR

Remarks

The character_expression argument must have the DT_WSTR data type.

REVERSE returns a null result if character_expression is null.

Expression Examples

This example uses a string literal. The return result is "ekiB niatnuoM".

REVERSE("Mountain Bike")  

This example uses a variable. If Name contains Touring Bike, the return result is "ekiB gniruoT".

REVERSE(@Name)  

See Also

Functions (SSIS Expression)