Help Center/Data Lake Insight/Spark SQL Syntax Reference/Built-In Functions/String Functions/soundex
Updated on 2023-10-25 GMT+08:00
View PDF

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