SELECT DIFFERENCE ( 'Fleas', 'Fleece') : Difference « String Functions « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. String Functions
  3. Difference

SELECT DIFFERENCE ( 'Fleas', 'Fleece')

 

4>
5> SELECT DIFFERENCE ( 'Fleas', 'Fleece')
6> GO

-----------
          3

(1 rows affected)
1>
2>








Related examples in the same category

1.DIFFERENCE(): a wrapper around two SOUNDEX() function calls and some business logic to compare the values
2.Using the DIFFERENCE() function to compare Redmond with Renton
3.DIFFERENCE: work out when one string sounds similar to another string