Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

Using String Functions to Search for Phonetically Similar Data

Locating a customer name. 6> 7> 8> SELECT DIFFERENCE("Kathy Ward","kathy WARD"), 9>        DIFFERENCE("KATHY Ward","Cathy Ward"), 10>        DIFFERENCE("KATHY Ward","Cathie Ward") 11> GO ----------- ----------- -----------           4           3           3 (1 rows affected)