RIGHT()

Scalar. Returns a specified number of characters from the end of a given string.

Syntax

RIGHT( string, count )

Data Types
Return	string	count
String	String	Integer

The following example uses the RIGHT function to extract the last 25 characters of the value in the Comments column:

INSERT INTO OutStream
SELECT RIGHT(Transactions.Comments,25)
FROM Transactions;