SOUNDEX

From MidrangeWiki
Revision as of 14:51, 26 June 2006 by David (talk | contribs)
Jump to: navigation, search

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