soundex

Description

Returns a 4-character code representing the way an expression sounds.

Syntax

soundex(char_expr | uchar_expr)

Parameters

char_expr

is a character-type column name, variable, or constant expression of char, varchar, nchar or nvarchar type.

uchar_expr

is a character-type column name, variable, or constant expression of unichar or univarchar type.

Examples

Example 1

select soundex ("smith"), soundex ("smythe")
----- -----  
S530  S530

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute soundex.

See also

Functions difference