This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
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 C 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 C 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 C STRING column, or a string literal | + | Required. This may be a CHARACTER or STRING column, or a string literal |
| ===== Example ===== | ===== Example ===== | ||