DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values : Difference « String Functions « SQL Server / T-SQL
DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values
1> -- DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values.
2>
3> -- reducing the result to a scale from 0 to 4, where the value 4 indicates a very close or exact match.
4>
5> SELECT DIFFERENCE('To', 'Two')
6>
7> GO