Share via


REVERSE (SSIS Expression)

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.

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)