REVERSE function [String]

Returns the reverse of a character expression.

Syntax
REVERSE( string-expression )
Parameters
  • string-expression   The string to be reversed.

Returns

LONG VARCHAR

LONG NVARCHAR

Remarks

This function supports NCHAR inputs and/or outputs.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value cba.

SELECT REVERSE( 'abc' );