SOUNDEX
All functions > STRING > SOUNDEX
Converts a string to its Soundex phonetic representation.
Syntax
SOUNDEX(expr)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
string | VARCHAR | Yes | String to convert to Soundex code |
Returns
Four-character Soundex code representing the phonetic sound
Notes
- Used for fuzzy string matching based on pronunciation
- Words that sound similar have the same Soundex code
- Result is always a letter followed by three digits
- Useful for matching names despite spelling variations