Soundex Functions in SQL Server 2008
In this article I am going to explain how to get soundex value of a string.
It is an algorithm that generates a simple code for a string. It converts a phrase to a four- character code based upon the way in which the word will be pronounced. The first character is the first letter of the phrase. Vowels are omitted till the first letter of the phrase is a vowel and other three letters represent the remaining phrase.
select soundex (character_expression'')
where character_expression specifies the string whose soundex value to be returned.
Suppose we have a table named "Employee" given in following image.
Select Soundex value for F_Name if Employee Table