Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

RIGHT (SQL)

A scalar string function that returns a specified number of characters from the end (rightmost position) of a string expression.

Synopsis

{fn RIGHT(string-expression,count)}

Arguments

Argument Description
string-expression A string expression, which can be the name of a column, a string literal, or the result of another scalar function, where the underlying data type can be represented as any character type (such as CHAR or VARCHAR).
count An integer that specifies the number of characters to return from the ending (rightmost) position of string-expression.

Description

RIGHT returns count number of characters from the end (rightmost position) of string-expression. RIGHT returns NULL if passed a NULL value for either argument.

RIGHT can only be used as an ODBC scalar function (with the curly brace syntax).

Examples

The following example returns the two rightmost characters of each name in the Sample.Person table:

SELECT Name,{fn RIGHT(Name,2)}AS MiddleInitial
     FROM Sample.Person

The following embedded SQL example shows how RIGHT handles a count that is longer than the string itself:

   &sql(SELECT Name,{fn RIGHT(Name,40)}
     INTO :a,:b
     FROM Sample.Person)
   IF SQLCODE'=0 {
     WRITE !,"Error code ",SQLCODE }
   ELSE {
     WRITE !,a,"=original",!,b,"=RIGHT 40" }

No padding is performed.

See Also

LEFT LTRIM RTRIM

Feedback