difference
Returns an integer value representing the difference between the values returned by the data source-specific soundex function for "string_expression1" and "string_expression2". The value that is returned ranges from 0 to 4, with 4 indicating the best match. Note that 4 does not mean that the strings are equal.
Syntax
difference ( string_expression1 , string_expression2 )Example 1
difference ([Sales target (query)].[Sales staff].[First name],[Sales (
query)].[Retailers].[Contact first name])Result
0
Example 2
difference ([Sales target (query)].[Sales staff].[First name],[Sales
target (query)].[Sales staff].[First name])Result
4