REVERSE()

Purpose

Function to return a character expression in reverse character sequence

Syntax

REVERSE(<expC>)

See Also

DESCEND(), EXPLAIN, INDEX, SEEK, SEEK(), SET EXPLAIN, SORT

Description

The REVERSE() function returns the character expression <expC> in reverse character sequence. It is most useful for creating indexes so that the SQL query optimizer can optimize WHERE <column> LIKE '%xxx' clauses.

Example

open database southwind
use customers
index on reverse(customerid) tag revcust
use
set explain on
select * from customers where customerid like '%K'