Difference between revisions of "DESCEND()"
From Lianjapedia
(→Products) |
Yvonne.milne (Talk | contribs) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return a character expression in inverse character sequence | Function to return a character expression in inverse character sequence | ||
| − | |||
==Syntax== | ==Syntax== | ||
DESCEND(<expC>) | DESCEND(<expC>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | + | [[INDEX]], [[SEEK]], [[SEEK()]], [[SORT]] | |
| − | + | ||
==Description== | ==Description== | ||
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. | 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. | ||
| − | |||
==Example== | ==Example== | ||
| Line 21: | Line 17: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Latest revision as of 05:56, 10 February 2012
Contents
Purpose
Function to return a character expression in inverse character sequence
Syntax
DESCEND(<expC>)
See Also
Description
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.
Example
index on descend(name) to descendname seek descend("Smith")
