REVERSE

Purpose

This function returns the reverse of a string value.

Syntax

reverse::=

Usage Notes

  • If string is NULL, the function returns NULL.
  • If the input parameter is not a string, it is automatically converted to a string.
  • The return type is always a string which has the length of the input parameter.

Example

Copy 
SELECT REVERSE('abcde') REVERSE;