Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

Determining the Similarity of Strings

3> 4> SELECT SOUNDEX('Fleas'), 5> SOUNDEX('Fleece'), 6> SOUNDEX('Peace'), 7> SOUNDEX('Peas') 8> GO ----- ----- ----- ----- F100  F120  P200  P000 (1 rows affected) 1>