String Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. String Functions
  4. SOUNDEX(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>