Neoview SQL Reference Manual (R2.4 SP2)

RIGHT Function
The RIGHT function returns the rightmost specified number of characters from a character
expression. Every character, including multibyte characters, is treated as one character.
RIGHT is a Neoview SQL extension.
RIGHT (character-expr, count)
character-expr
specifies the source string from which to return the rightmost specified number of characters.
The source string is an SQL character value expression. The operand is the result of evaluating
character-expr. See “Character Value Expressions” (page 243).
count
specifies the number of characters to return from character-expr. The number count must
be a value of exact numeric data type with a scale of zero.
Examples of RIGHT
• Return 'Smith':
RIGHT ('Robert John Smith', 5)
• Suppose that a six-character company literal has been concatenated as the first six characters
to the job descriptions in the JOB table. Use the RIGHT function to remove the company
literal from the job descriptions:
UPDATE persnl.job
SET jobdesc = RIGHT (jobdesc, 12);
RIGHT Function 437