Difference function in SQL Server

Question

What is Difference function in SQL Server?

Jignesh Trivedi · Answer

hi SOUNDEX converts an alphanumeric string to a four-character code to find similar-sounding words or names. The first character of the code is the first character of character_expression and the 2nd to 4th characters of the code are numbers that represent the letters in the expression. DIFFERENCE function returns an integer value.It value range is 0 to 4.The integer returned is the number of characters in the SOUNDEX values that are the same.it indicates weak or no similarity and 4 indicates strong similarity or the same values. SELECT SOUNDEX('myCode') SOUNDEX('myCodee') DIFFERENCE('myCode''myCode'); --out put M230M2304 SELECT SOUNDEX('KyCode') SOUNDEX('myCode') DIFFERENCE('myCode''KyCode'); --out put K230M2303 Pls refer http://msdn.microsoft.com/en-us/library/ms188753.aspx http://www.dotnetspider.com/resources/36569-Difference-function-SQL-Server.aspx