/ Published in: SQL
A few examples of the SOUNDEX function.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
--SOUNDEX --Example 1 SELECT SOUNDEX('Complete') AS testval FROM dual; --Example 2 SELECT SOUNDEX('complete') AS testval FROM dual; --Example 3 SELECT SOUNDEX('Canne'), SOUNDEX('Can') FROM dual; --Example 4 SELECT first_name, last_name FROM student WHERE SOUNDEX(last_name) = SOUNDEX('Smyth');
URL: http://www.databasestar.com/oracle-soundex/