LinkSolv 8.3 Help Pages and User Guide

Compare Methods

Compare Methods
1

Delta Days

1. Delta Days
 
DeltaDays computes the number of days between two dates. Postive differences mean the second date is later than the first. DeltaDays is similar to the native Access function DateDiff.
2

Delta Exact

2. Delta Exact
 
Delta Exact calculates whether two character values are identical. Agreement is coded as 0 and disagreement is coded as 1.
3

Delta Hours

3. Delta Hours
 
DeltaHours calculates the number of hours between two times. The difference is calculated clockwise and counter-clockwise and the smaller of the two differences is used.
4

Delta Miles

4. Delta Miles
 
DeltaMiles calculates the distance in miles between two latitude/longitude locations using spherical geometry.
5

Delta Minutes

5. Delta Minutes
 
DeltaMinutes calculates the number of minutes between two times. The difference is calculated clockwise and counter-clockwise and the smaller of the two differences is used.
6

Delta Null

6. Delta Null
 
DeltaNull
7

Delta Number

7. Delta Number
 
DeltaNumber calculates the difference between two values treated as whole numbers. Differences are positive if the second value is greater than the first.
8

Delta Number Pct

8. Delta Number Pct
 
DeltaNumberPct calculates the difference between two values treated as whole numbers expressed as a percent of the first. Differences are greater than 100% if the second value is greater than the first, and can be positive or negative. Differences are not defined if the smaller value is 0.
9

Delta Prefix

9. Delta Prefix
 
DeltaPreix calculates the number of typo differences between two character values up to the length of the shorter -- S vs Smith has 0 typos difference. Each insertion/deletion counts as 1 typo and each transposition counts as 1 typo.
10

Delta Prefix Pct

10. Delta Prefix Pct
 
DeltaPreixPct calculates the number of typo differences between two character values up to the length of the shorter expressed as a percent of the shorter. Each insertion/deletion counts as 1 typo and each transposition counts as 1 typo.
11

Delta Soundex

11. Delta Soundex
 
DeltaSoundex calculates SOUNDEX codes for text values and then counts the number of different characters in the two SOUNDEX codes. DeltaSoundex is similar to the native SQL Server DIFFERENCE function.
12

Delta Soundex Pct

12. Delta Soundex Pct
<TODO>: Insert description text here...
13

Delta Typos

13. Delta Typos
 
DeltaTypos calculates the number of typo differences between two character values. Each insertion/deletion counts as 1 typo and each transposition counts as 1 typo.
14

Delta Typos Pct

14. Delta Typos Pct
 
DeltaTyposPct calculates the number of typo differences between two character values expressed as a percent of the shorter. Each insertion/deletion counts as 1 typo and each transposition counts as 1 typo.
15

Method List Navigation Controls

15. Method List Navigation Controls
Go to the first record
Authored with help of Dr.Explain