Difference between revisions of "SOUNDEX"
From MidrangeWiki
m |
m |
||
| Line 1: | Line 1: | ||
| + | [[Category:SQL]] | ||
| + | [[Category:Database]] | ||
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'''. | 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'''. | ||
Revision as of 14:51, 26 June 2006
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
