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 soundex()
    Short Returns a phonetic string
    Parameter s : any String
    Return To "phonetics" reduced value of s
    See also:
    HAS LIKE strcomp()
    Description x like y

    is evaluated internal as

    The function SOUNDEX returns a very simple phonetic picture of a string. Following the rules:

    The first letter is taken over without a change.
    The following chars are coded from left to right on this way:

    'B','F','P','V' -> '1'
    'C','G','K','Q','S','X','Z','ß' -> '2'
    'D','T' -> '3'
    'L' -> '4'
    'M','N' -> '5'
    'R' -> '6'

    All other chars are skipped. A letter is also skipped if it returns the same code like the last one.

    Only the first four characters of the resulting string are used.

    The disadvantage is that many different words match and a search returns a to big number of hits.

    Though SOUNDEX has nothing to do with the operator "HAS", which is based on the function POS again.

    If the searched item is not at the beginning of the string you will not have luck with "ähnlich".

    Better than "ähnlich" or "enthält" is in all cases the use of "wie" and "in" or of STRCMP (for special applications).

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