Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- The Guide To Clipper - <b>soundex()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
SOUNDEX()


Syntax:     SOUNDEX(<expC>)

Purpose:    To convert a character string to soundex form (phonetic
            complement) useful for INDEXing and searching.

Argument:   <expC> is the character string to convert to soundex
            form.

Returns:    A character string.

            The string returned is a code in the form A9999.

Usage:      SOUNDEX() is useful for creating indexes and searching for
            strings where the precise spelling is unknown.

Library:    EXTEND.LIB

Source:     EXAMPLEC.C


----------------------------------- Example --------------------------------

   USE Sales
   INDEX ON SOUNDEX(Salesman) TO Salesman
   *
   SEEK SOUNDEX("Bill")
   ? FOUND(), Salesman            && Result: .T. Bill

   SEEK SOUNDEX("Billy")
   ? FOUND(), Salesman            && Result: .T. Bill


See Also: INDEX LOCATE SEEK SET SOFTSEEK

Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson