8.3.13. REVERSE()
Available in
DSQL, PSQL
Syntax
REVERSE (string)
Parameter | Description |
---|---|
string | An expression of a string type |
Result type
VARCHAR
Description
Returns a string backwards.
Examples
reverse ('spoonful') -- returns 'lufnoops'
reverse ('Was it a cat I saw?') -- returns '?was I tac a ti saW'
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:
|