Deutsch English
Alphabetical index
Array functions
CGI functions
Data types
Date functions
Fulltext functions
Language elements
Numerical functions
Other functions
Ramtext functions
Socket functions
Statistical functions
Stream functions
String functions
  • ansitooem()
  • asc()
  • chr()
  • decodeb64()
  • digitstr()
  • encodeb64()
  • exchange()
  • extnote()
  • fillstr()
  • groß()
  • isnumber()
  • klein()
  • länge()
  • leftstr()
  • length()
  • links()
  • lower()
  • ltrim()
  • makepw()
  • ntimes()
  • oemtoansi()
  • pos()
  • rechts()
  • rightstr()
  • rtrim()
  • scan()
  • soundex()
  • stradd()
  • strcomp()
  • subpath()
  • swap()
  • testln()
  • testpw()
  • tohtml()
  • upper()
  • valstr()
    System functions
    Table functions
    Text functions
    Home    Overview    Search    Impressum    Contact    Members
    Topic complex String functions
    Function swap()
    Short Inversion of a string with reference to the start of sorting
    Syntax SWAP(s : STRING) : STRING
    Parameter s : any string
    Return s, if s includes no '^',
    otherwise 'b^a', if s has the form 'a^b'.
    See also:
    Description The databases of the TDB family support the sign of start of sorting '^' in strings. That means that strings in the form 'a^b' are not sorted under 'a...' but under 'b...'. At sorting surch strings a SWAP(...) is executed internal.
    Example: A typical case of a problem are titles of nobility in name fields. The name 'von Eisenstein' is normally sorted under 'von...' thus a search over indices for 'Eisenstein' would fail. But is the name entered as 'von^Eisenstein' the name is sorted under 'Eisenstein...' and also found.

    User comments:
    Write a comment:
    Text (Switch mode)

    Choose between
    the normal and the
    advanced editor.
    The advanced editor
    runs in IE 5+ and
    Mozilla 1.4+ only
    SPAM-Protection Please enter tdbengine in this field.

    tdbengine chat

       Copyright © 2003-2004 tdb Software Service GmbH
       Alle rechte vorbehalten. / All rights reserved
       Last changed: 21.10.2004
    {Fehler für :execmacro{execmacro="sessionspy"}