Mega Code Archive

 

Categories / MSSQL Tutorial / String Functions

 

DIFFERENCE(Nite, Knight)

5>  SELECT 6> "SX_KNIGHT"=SOUNDEX('Knight'), 7> "SX_NITE"=SOUNDEX('Nite'), 8> "DIFFERENCE"=DIFFERENCE('Nite', 'Knight') 9> GO SX_KNIGHT SX_NITE DIFFERENCE --------- ------- ----------- K523      N300              1 (1 rows affected) 1>