ASA SQL Reference

SQL Functions

Alphabetical list of functions

RIGHT function [String]

Function 

Returns the rightmost characters of a string.

Syntax 

RIGHT ( string-expression, integer-expression )

Parameters 

string-expression    The string to be left-truncated.

integer-expression    The number of characters at the end of the string to return.

Usage 

If the string contains multi-byte characters, and the proper collation is being used, the number of bytes returned may be greater than the specified number of characters.

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

• LEFT function [String]
• International Languages and Character Sets

Example 

The following statement returns the value olate.

SELECT RIGHT( 'chocolate', 5 )

SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.