REVERSE()

<< REPLACE() | FB 2.5 Language Reference | RIGHT() >>
<< REPLACE() | FB 2.1 Language Reference | RIGHT() >>

REVERSE()

Available in: DSQL, PSQL

Added in: 2.1

Description

Returns a string backwards.

Result type: VARCHAR

Syntax

 REVERSE (str)

Examples

 reverse ('spoonful')              -- returns 'lufnoops'
 reverse ('Was it a cat I saw?')   -- returns '?was I tac a ti saW'

Tip: This function comes in very handy if you want to group, search or order on string endings, e.g. when dealing with domain names or email addresses:

 create index ix_people_email on people
   computed by (reverse(email));

 select * from people
   where reverse(email) starting with reverse('.br');

back to top of page
<< REPLACE() | FB 2.5 Language Reference | RIGHT() >>
<< REPLACE() | FB 2.1 Language Reference | RIGHT() >>