meta data for this page
REVERSE()
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');