INF: DIFFERENCE() and SOUNDEX() Functions in Transact-SQL (100365)
The information in this article applies to:
- Microsoft SQL Server 7.0
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
- Microsoft SQL Server 6.5 Service Pack 1 and later
- Microsoft SQL Server 6.5 Service Pack 2 and later
- Microsoft SQL Server 6.5 Service Pack 3 and later
- Microsoft SQL Server 6.5 Service Pack 4 and later
- Microsoft SQL Server 6.5 Service Pack 5 and 5a
- Microsoft SQL Server 6.5 Service Pack 5a
- Microsoft SQL Server 7.0 Service Pack 1
This article was previously published under Q100365 SUMMARY
The DIFFERENCE() and SOUNDEX() functions in Transact-SQL allow searches on character strings that "sound similar." SOUNDEX() converts each string into a 4-digit code. DIFFERENCE() can then be used to evaluate the level of similarity between the soundexes for two strings as returned by SOUNDEX(). For example, these functions could be used in a case where you wanted to look at all rows that sound like
"Erickson," so it should find those with "Erickson," "Erikson,"
"Ericson," "Ericksen," "Ericsen," and so on.
Modification Type: | Major | Last Reviewed: | 6/29/2004 |
---|
Keywords: | kbinfo kbother KB100365 |
---|
|