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

Sql LOCATE function

The LOCATE function returns the starting position of the first occurrence of search- string within   source-string Example  : Exec Sql Select Locate(‘N’, ‘NASHVILLE’) From Sysibm/Sysdummy1; Result is 1