Deutsch English
Alphabetical index
Array functions
CGI functions
Data types
Date functions
Debugging
Fulltext functions
Language elements
Numerical functions
Operators
Other functions
Ramtext functions
Selecting
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:
    Name
    EMail
    Subject
    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
    irc.tdbengine.org
    #tdbengine

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