Difference between revisions of "DESCEND()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Products)
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return a character expression in inverse character sequence
 
Function to return a character expression in inverse character sequence
Line 27: Line 23:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 16:56, 27 November 2009

Purpose

Function to return a character expression in inverse character sequence


Syntax

DESCEND(<expC>)


See Also

FIND, INDEX, SEEK, SEEK(), SORT


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")


Products

Recital Server, Recital