Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
dev:sql:functions:soundex [2009/12/07 16:57]
tdo
dev:sql:functions:soundex [2016/06/28 22:38] (current)
Line 4: Line 4:
 {{page>:​sql_bar&​nofooter&​noeditbtn}} {{page>:​sql_bar&​nofooter&​noeditbtn}}
 ===== Description ===== ===== Description =====
-Returns the Soundex equivalent to a character string ("​string"​ may be a CHARACTER or STRING column, or a string literal). The algorithm used by this function is identical to that applied to keywords in MDK index using the ;SX option. The routine only pays attention to the first 24 characters of the input; the return value is STRING length 25.+Returns the Soundex equivalent to a character string ("​string"​ may be a CHARACTER or STRING column, or a string literal). The algorithm used by this function is identical to that applied to keywords in MDK index using the ;SX option. The routine only pays attention to the first 24 characters of the input; the return value is STRING length 25.
  
 Note that the $SOUNDEX function does not parse fields, and therefore returns the Soundex equivalent of the entire string. For example, the Soundex equivalent of "​Dynamic Information Systems Corporation"​ is "​DNMKNFRMTNSSTMSKRP"​. Note that the $SOUNDEX function does not parse fields, and therefore returns the Soundex equivalent of the entire string. For example, the Soundex equivalent of "​Dynamic Information Systems Corporation"​ is "​DNMKNFRMTNSSTMSKRP"​.
Line 11: Line 11:
  
 For more information on Soundex searches, also known as Phonetic searches, see Omnidex Text and Phonetic Searches. For more information on Soundex searches, also known as Phonetic searches, see Omnidex Text and Phonetic Searches.
- 
 ===== Syntax ===== ===== Syntax =====
 +  $SOUNDEX( <​column_spec | '​string'​ >)
 +
 +<​column_spec | '​string'​ >
 +
 +Required. This may be a CHARACTER or STRING column, or a string literal ​
 +
 ===== Example ===== ===== Example =====
 ==== Example 1 ==== ==== Example 1 ====
 
Back to top
dev/sql/functions/soundex.1260205068.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)