Difference between revisions of "SOUNDEX()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to perform phonetic similarity evaluation
 
Function to perform phonetic similarity evaluation
Line 28: Line 26:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:String Data]]
 
[[Category:String Data]]
 
[[Category:String Data Functions]]
 
[[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

DIFFERENCE(), INDEX


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