soundex¶
This function is used to return the soundex string from str, for example, soundex('Miller') = M460.
Syntax¶
soundex(string <str>)
Parameters¶
Parameter | Mandatory | Type | Description |
|---|---|---|---|
str | Yes | STRING | String to be converted |
Return Values¶
The return value is of the STRING type.
Note
If the value of str is NULL, NULL is returned.
Example Code¶
The value M460 is returned.
SELECT soundex('Miller');