Month: May 2018
Sql Soundex Function
The Soundex function returns a 4-character code that represents the sound of the words in the argument. Example : Use the Soundex function to find a row where the sound of the LASTNAME value closely matches the phonetic spelling of ‘Loucesy’: Select Empno, Lastname From EmployeeTable Where Soundex(Lastname) = Soundex(‘Loucesy’); This example returns the following […]