Difference between revisions of "SOUNDEX"

From MidrangeWiki
Jump to: navigation, search
m
Line 5: Line 5:
 
STRSQL
 
STRSQL
  
SELECT fieldname FROM libraryname/filename WHERE SOUNDEX)fieldname) = SOUNDEX('prtsit') ORDER BY fieldname
+
SELECT fieldname FROM libraryname/filename WHERE SOUNDEX {fieldname) = SOUNDEX('prtsit') ORDER BY fieldname

Revision as of 04:14, 28 May 2005

The SQL function SOUNDEX can find a character string for which the sound is known, but the exact spelling is not. For example, the following searches the file for a name that sounds like prtsit and returns the name Pritchett.

From Command Line or equivalent

STRSQL

SELECT fieldname FROM libraryname/filename WHERE SOUNDEX {fieldname) = SOUNDEX('prtsit') ORDER BY fieldname