Loading lesson path
Concept visual
Start at both ends
Formula
Evaluate the similarity of two strings, and return a four - character code:SELECT SOUNDEX('Juice'), SOUNDEX('Jucy');Formula
The SOUNDEX() function returns a four - character code to evaluate the similarity of two expressions.Formula
The SOUNDEX() converts the string to a four - character code based on how the string sounds when spoken.Also look at the DIFFERENCE() function.
expression )
Required. The expression to evaluate. Can be a constant, variable, or column
SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse
Formula
Evaluate the similarity of two strings, and return a four - character code:SELECT SOUNDEX('Juice'), SOUNDEX('Banana');❮ SQL Server Functions