REVERSE()

All functions > STRING > REVERSE()

Returns the string with all characters in reverse order.

Signatures

Returns: String with characters in reverse order

REVERSE(string: VARCHAR) → VARCHAR
sql
ParameterTypeRequiredDescription
stringVARCHARYesString to reverse

Notes

  • Reverses the string’s characters in display order (including non-ASCII characters as single code points)
  • REVERSE('') is ''; if the input is NULL the result is NULL (use NULL(VARCHAR); bare NULL fails inference)
  • A palindrome is unchanged after reversal

Examples

FeatureQL
SELECT
    f1 := REVERSE('Hello World'), -- Reverse entire string
    f2 := REVERSE('ABCDEF'), -- Alphabetic reversal
    f3 := REVERSE('12345'), -- Numeric string reversal
    f4 := REVERSE('racecar'), -- Palindrome stays same
    f5 := REVERSE('A'), -- Single character
    f6 := REVERSE('café'), -- Non-ASCII reversal
    f7 := REVERSE(''), -- Empty string
    f8 := REVERSE(NULL(VARCHAR)) -- NULL yields NULL
;
Result
f1 VARCHARf2 VARCHARf3 VARCHARf4 VARCHARf5 VARCHARf6 VARCHARf7 VARCHARf8 VARCHAR
dlroW olleHFEDCBA54321racecarAéfac(empty)NULL

Suggest changes to this page
Last update at: 2026/05/26 17:22:09