SoundEx Function |  |
Convert a string to Soundex form.
Namespace: XSharp.Core
Assembly: XSharp.Core (in XSharp.Core.dll) Version: 2.19
SyntaxRequest Example
View Source
A 4-digit string starting with an alphabetic character and ending with three digits.
Parameters
- cString
- Type: String
The string to convert.
Return Value
Type: StringA 4-digit string starting with an alphabetic character and ending with three digits.
Remarks
Soundex() is a character function that indexes and searches for sound-alike or phonetic matches.
It is used in applications where the precise spelling of character keys is not known or where there is a high probability of misspelled names. Misspelling is common in real-time transaction systems where the data entry operator is receiving information over the telephone. Soundex() works by bringing sound-alikes together under the same key value. Note, however, the soundex method is not absolute. Keys that are quite different can result in the same soundex value.
It is used in applications where the precise spelling of character keys is not known or where there is a high probability of misspelled names. Misspelling is common in real-time transaction systems where the data entry operator is receiving information over the telephone. Soundex() works by bringing sound-alikes together under the same key value. Note, however, the soundex method is not absolute. Keys that are quite different can result in the same soundex value.
Examples
This example builds an order using Soundex() to create the key values.
It then searches for a value found in the Salesman field:
Here, a search is made for the same key as above but with a different spelling:
It then searches for a value found in the Salesman field:
X#
1USE sales 2INDEX ON Soundex(Salesman) TO salesman 3SEEK Soundex("Smith") 4? Found(), salesman // TRUE Smith
X#
1SEEK Soundex("Smythe") 2? Found(), salesman // TRUE Smith
See Also