RIGHT (SSIS Expressions)
Returns the part of a character expression that begins at and is to the right of a specified character position counting from the right.
Use the SUBSTRING function to extract a number of characters from the left. For more information, see SUBSTRING (SSIS Expressions).
If integer_expression is greater than the length of character_expression, the function returns character_expression.
If integer_expression is zero, the function returns a zero-length string.
If integer_expression is a negative number, the function returns an error.
The number argument can take variables and columns.
RIGHT works only with the DT_WSTR data type. A character_expression argument that is a string literal or a data column with the DT_STR data type is implicitly cast to the DT_WSTR data type before RIGHT performs its operation. Other data types must be explicitly cast to the DT_WSTR data type. For more information, see Integration Services Data Types and Cast (SSIS Expressions).
RIGHT returns a null result if either argument is null.
This example uses a string literal. The return result is "Bike".
RIGHT("Mountain Bike", 4)
This example returns the number of right-most characters that is specified in the Times variable, from the Name column. If Name is Touring Front Wheel and Times is 5, the return result is "Wheel".
This example also returns the number of right-most characters that is specified in the Times variable, from the Name column. Times has a noninteger data type and the expression includes an explicit cast to the DT_I2 data type. If Name is Touring Front Wheel and Times is 4.32, the return result is "heel". The value 4.32 is converted to 4 and the right four characters are returned.