Difference between revisions of "SOUNDEX()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to perform phonetic similarity evaluation | Function to perform phonetic similarity evaluation | ||
| Line 25: | Line 18: | ||
<code lang="recital"> | <code lang="recital"> | ||
if soundex("Jonas") = soundex("Jones") | if soundex("Jonas") = soundex("Jones") | ||
| − | + | ? "These names are phonetically similar." | |
endif | endif | ||
index on soundex(name) to similars | index on soundex(name) to similars | ||
| Line 33: | Line 26: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:String Data]] | ||
| + | [[Category:String Data Functions]] | ||
Latest revision as of 16:27, 7 December 2009
Purpose
Function to perform phonetic similarity evaluation
Syntax
SOUNDEX(<expC>)]]
See Also
Description
The SOUNDEX() function returns a code that represents the equivalent of <expC>. By comparing the codes that are returned for different words, it is possible to check whether different character strings sound alike. The SOUNDEX() function is particularly useful when used with indexes. The "?" operator, which appears in the query menu, operates a sounds-like comparison between two strings. The comparison returns .T. if two strings are phonetically similar.
Example
if soundex("Jonas") = soundex("Jones") ? "These names are phonetically similar." endif index on soundex(name) to similars display all for "Jones" ? name
Products
Recital, Recital Server
