SQL Server DIFFERENCE() Function
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
SQL Server DIFFERENCE() Function
❮ SQL Server Functions
Example
Compares two SOUNDEX values, and return an integer:
SELECT DIFFERENCE('Juice', 'Jucy');Try it Yourself »
Definition and Usage
The DIFFERENCE() function compares two SOUNDEX values, and returns an
integer. The integer value indicates the match for the two SOUNDEX values, from 0 to 4.
0 indicates weak or no similarity between the SOUNDEX values. 4
indicates strong similarity or identically SOUNDEX values.
Tip: Also look at the SOUNDEX()
function.
Syntax
DIFFERENCE(expression, expression)Parameter Values
| Parameter | Description |
|---|---|
| expression, expression | Required. Two expressions to be compared. Can be a constant, variable, or column |
Technical Details
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
|---|
More Examples
Example
Compares two SOUNDEX values, and return an integer:
SELECT DIFFERENCE('Juice', 'Banana');Try it Yourself »
❮ SQL Server Functions
