Skip to content

Commit c137bb0

Browse files
authored
Update difference-transact-sql.md
Text revisions to tighten and optimize the reading flow of the material.
1 parent 99e355b commit c137bb0

1 file changed

Lines changed: 8 additions & 8 deletions

File tree

docs/t-sql/functions/difference-transact-sql.md

Lines changed: 8 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@ monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest |
2929
# DIFFERENCE (Transact-SQL)
3030
[!INCLUDE[tsql-appliesto-ss2008-all-md](../../includes/tsql-appliesto-ss2008-all-md.md)]
3131

32-
Returns an integer value that indicates the difference between the SOUNDEX values of two character expressions.
32+
This function returns an integer value measuring the difference between the [SOUNDEX()](./soundex-transact-sql.md) values of two different character expressions.
3333

3434
![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md)
3535

@@ -40,19 +40,19 @@ DIFFERENCE ( character_expression , character_expression )
4040
```
4141

4242
## Arguments
43-
*character_expression*
44-
Is an alphanumeric [expression](../../t-sql/language-elements/expressions-transact-sql.md) of character data. *character_expression* can be a constant, variable, or column.
43+
*character_expression*
44+
An alphanumeric [expression](../../t-sql/language-elements/expressions-transact-sql.md) of character data. *character_expression* can be a constant, variable, or column.
4545

4646
## Return Types
47-
**int**
48-
47+
**int**
48+
4949
## Remarks
50-
The integer returned is the number of characters in the SOUNDEX values that are the same. The return value ranges from 0 through 4: 0 indicates weak or no similarity, and 4 indicates strong similarity or the same values.
50+
`DIFFERENCE` compares two different `SOUNDEX` values, and returns an integer value. This value measures the degree that the `SOUNDEX` values match, on a scale of 0 to 4. A value of 0 indicates weak or no similarity between the SOUNDEX values; 4 indicates strongly similar, or even identically matching, SOUNDEX values.
5151

52-
DIFFERENCE and SOUNDEX are collation sensitive.
52+
`DIFFERENCE` and `SOUNDEX` have collation sensitivity.
5353

5454
## Examples
55-
In the first part of the following example, the `SOUNDEX` values of two very similar strings are compared. For a Latin1_General collation `DIFFERENCE` returns a value of `4`. In the second part of the following example, the `SOUNDEX` values for two very different strings are compared, and for a Latin1_General collation `DIFFERENCE` returns a value of `0`.
55+
The first part of this example compares the `SOUNDEX` values of two very similar strings. For a Latin1_General collation, `DIFFERENCE` returns a value of `4`. The second part of the example compares the `SOUNDEX` values for two very different strings, and for a Latin1_General collation, `DIFFERENCE` returns a value of `0`.
5656

5757
```
5858
-- Returns a DIFFERENCE value of 4, the least possible difference.

0 commit comments

Comments
 (0)