A*******n 发帖数: 625 | 1 Returns a four-character (SOUNDEX) code to evaluate the similarity of two
strings.
这个“four-character”到底是什么啊,和什么string比?
Returning the SOUNDEX for Smith and Smythe returns the same SOUNDEX result
because all vowels, the letter y, doubled letters, and the letter h, are not
included.
-- Using SOUNDEX
SELECT SOUNDEX ('Smith'), SOUNDEX ('Smythe');
----- -----
S530 S530
(1 row(s) affected)
这个S530怎么来的?
这个原因也很怪“because all vowels, the letter y, doubled letters, and the
letter h, are not included”。按这个原因,Smith=smt, smythe= smt。2个是一样
。 可是为什么会有这东西? |