Function to return a character expression in inverse character sequence
The DESCEND() function returns the character expression <expC> in inverse character sequence. This function operates by subtracting the code for each character from 255. It is most useful for creating indexes in descending order of key. To search in such indexes, the DESCEND() function must be used.
index on descend(name) to descendname seek descend("Smith")