<div dir="ltr"><div><span style="font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.95px;white-space:pre-wrap">We tried to use soundex in where clause, but kept getting the following error.</span></div><span style="font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.95px;white-space:pre-wrap"><div><span style="font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace;font-size:12.95px;white-space:pre-wrap"><br></span></div>ERROR:  function soundex(text) does not exist
LINE 1: ...(pao_start_number,pao_end_number,1) as index) or (soundex(fu...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 495</span>  <br><div><br></div><div>Can anyone enlighten me?</div><div><br></div><div>Regards,</div><div><br></div><div>David</div></div>