soundex

Updated on 2023-10-25 GMT+08:00

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.

NOTE:

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

Example Code

The value M460 is returned.

SELECT soundex('Miller');
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback