Skip to Content

Default language.

Information
Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Stats for Db2 13.1.

SOUNDEX

The SOUNDEX function returns a four-character code that represents the sound of the single argument. The product can compare the result with the results of the SOUNDEX function of other strings.

SOUNDEX.png

expression must return a character, or a varying character. The string is cast to Unicode SBCS CCSID 367 before generating the SOUNDEX code.

Warning

Important

You cannot specify expression as a constant string, but you can specify it as CHAR(expression,n).

The data type of the result is CHAR (4) in Unicode SBCS CCSID.

The SOUNDEX function is useful for finding strings for which the sound is known but the precise spelling is not. The function's assumptions about the way letters and combinations of letters sound can help you search for words with similar sounds. The SOUNDEX function produces the same code as the Db2 SOUNDEX function. The Special Census method generates the code.

Information
Example
SELECT SOUNDEX(CHAR ('ashcraft', 8)) FROM SYSIBM.SYSDUMMY1

results in A226


Related topics

Functions-that-the-BMC-AMI-Utilities-SQL-language-supports

Features-that-the-BMC-AMI-Utilities-SQL-language-supports


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Stats for Db2 12.1