Differences

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

Link to this comparison view

dev:sql:functions:soundex [2009/12/07 16:58]
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 16: Line 16:
 <column_spec | 'string' > <column_spec | 'string' >
  
-Required. This may be a CHARACTER or STRING column, or a string literal +Required. This may be a CHARACTER or STRING column, or a string literal 
  
 ===== Example ===== ===== Example =====
 
Back to top
dev/sql/functions/soundex.1260205121.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
 
 
chimeric.de = chi`s home Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0