Convert a string to Soundex form.
XSharp.Core (in XSharp.Core.dll) Version: 2.7
Syntax Request Example
cString AS STRING
) AS STRING
public static string SoundEx(
- Type: String
The string to convert.
A 4-digit string starting with an alphabetic character and ending with three digits.
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.
This example builds an order using Soundex() to create the key values.
It then searches for a value found in the Salesman field:
2INDEX ON Soundex(Salesman) TO salesman
4? Found(), salesman
Here, a search is made for the same key as above but with a different spelling:
2? Found(), salesman