soundex function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Returns the soundex code of the string.

Syntax 

soundex(expr)

Arguments

  • expr: A STRING expression.

Returns

A STRING.

Examples 

> SELECT soundex('Miller');
 M460