[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
+---------------------------------+
| DIFFERENCE |
+---------------------------------+
DIFFERENCE(<expC1>, <expC2>)
-----------------------------------
Returns relative phonetic difference between <expC1> and <expC2>.
Return value - Numeric
-----------------------------------
This function returns a numeric value between 0 and 4 that represents a
relative phonetic difference between the two character expressions.
DIFFERENCE() is useful for searching databases when the exact spelling
of an entry isn't known.
If the character expressions are very similar phonetically, DIFFERENCE()
returns a value of 4. Two character expressions with little in common
phonetically return a 0.
<expC1>, <expC2>
The character expressions that are compared by DIFFERENCE() are
specified by <expC1> and <expC2>.
+---------------------------------+
| Examples |
+---------------------------------+
STORE 'Smith' TO name1
STORE 'Smythe' TO name2
STORE 'Smittie' TO name3
STORE '' TO name4
? DIFFERENCE(name1, name2)
? DIFFERENCE(name1, name3)
? DIFFERENCE(name1, name4)
-----------------------------------
See Also: SOUNDEX()
-----------------------------------
See Also:
SOUNDEX()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson