Back to Function Index

REVERSE()

Overview

REVERSE() reverses the order of the characters in a string, creating a mirror image of the input string. This function is useful for string manipulation, pattern matching, and text analysis.

Function Format

REVERSE(string)

Return Value

REVERSE() returns a character string

Examples

REVERSE("APPLES") = "SELPPA"
REVERSE("ORANGES") = "SEGNARO"
REVERSE("12345") = "54321"
REVERSE("") = ""                    // Empty string
REVERSE("A") = "A"                 // Single character
REVERSE("HELLO WORLD") = "DLROW OLLEH"  // Multiple words

Notes

• Important behaviors:
  • Reverses all characters in the input string
  • Preserves spaces and special characters
  • Returns empty string for empty input
  • Returns same string for single character input
  • Case sensitive - preserves original character case
• Common use cases include:
  • String manipulation
  • Palindrome checking
  • Text analysis
  • Pattern matching
  • Data transformation
• The function is useful for:
  • Creating mirror images of text
  • Reversing data sequences
  • Text processing
  • String comparison

See Also

• LENGTH()
• SUBSTR()
• TRIM()
• LOWER()