Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

4.2 KiB

Raw Permalink Blame History

soundex

This function is used to return the soundex string from str, for example, soundex('Miller') = M460.

Syntax

soundex(string <str>)

Parameters

**Table 1** Parameter
Parameter	Mandatory	Type	Description
str	Yes	STRING	String to be converted

Return Values

The return value is of the STRING type.

If the value of str is NULL, NULL is returned.

Example Code

The value M460 is returned.

SELECT soundex('Miller');

Parent topic: String Functions

4.2 KiB Raw Permalink Blame History