Returns the rightmost characters of a string.
RIGHT( string-expression, integer-expression )
string-expression The string to be left-truncated.
integer-expression The number of characters at the end of the string to return.
LONG VARCHAR
LONG NVARCHAR
If the string contains multibyte characters, and the proper collation is being used, the number of bytes returned may be greater than the specified number of characters.
You can specify an integer-expression that is larger than the value in the column. In this case, the entire value is returned.
This function supports NCHAR inputs and/or outputs. Whenever possible, if the input string uses character length semantics the return value will be described in terms of character length semantics.
SQL/2003 Vendor extension.
The following statement returns the last 5 characters of each Surname value in the Customers table.
SELECT RIGHT( Surname, 5) FROM Customers; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |