+---------------------------------+
|    SYS(15, <expC1>, <expC2>)    |
+---------------------------------+

-----------------------------------
Translates second character string by first character string.
Return value - Character
-----------------------------------

Primarily intended for European users who use letters with diacritical
marks.

These special characters typically have the high-bit set to 1.
Moreover, since there are different versions of most vowels (with
different diacritical marks), indexing on fields containing such
characters does not preserve normal alphabetical order.

This function takes each character of the string <expC2> and uses the
character's numeric value as a subscript into the table <expC1>,
replacing the character in <expC2> with the character found at that
position in the table.

If table <expC1> does not have a character corresponding to a character
from <expC2>, those characters from <expC2> are not translated.

We have included a sample translation table in a memory variable file
called EUROPEAN.MEM.  Stored in this memory variable file is a character
variable also called EUROPEAN.  This table translates a character with a
diacritical mark to the corresponding character minus the diacritical
mark.

+---------------------------------+
|             Example             |
+---------------------------------+
In this example, SYS(15) is used to index a database on a field
containing characters with diacritical marks while preserving normal
alphabetical order.

INDEX ON SYS(15, EUROPEAN, field) TO file

-----------------------------------

See Also:  CHRTRAN(), STRTRAN(), SYS()

-----------------------------------