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