String Functions MSSQL Tutorial

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)