RIGHT()

All functions > STRING > RIGHT()

Returns the last n characters of the string (or the full string when n is greater than its length).

Signatures

Returns: Trailing substring

RIGHT(string: VARCHAR, n: BIGINT) → VARCHAR

Notes

• Shorthand for taking a suffix; for a 1-indexed start and length, use SUBSTR instead
• For n larger than the string length, the whole string is returned; for n = 0, the result is ''
• If STRING or N is NULL, the result is NULL (use NULL(VARCHAR) / NULL(BIGINT); bare NULL fails inference)

Examples

SELECT
    -- Last three characters
    f1 := RIGHT('abcdef', 3),
    -- Matches SUBSTR for the same suffix
    f2 := RIGHT('abcdef', 3),
    -- n longer than string
    f3 := RIGHT('hi', 10),
    -- Zero length
    f4 := RIGHT('x', 0),
    -- NULL count yields NULL
    f5 := RIGHT('x', NULL(BIGINT))
;