Difference between revisions of "SOUNDEX"
From MidrangeWiki
m |
|||
Line 5: | Line 5: | ||
STRSQL | STRSQL | ||
− | SELECT fieldname FROM libraryname/filename WHERE SOUNDEX | + | 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