SOUNDEX( ) example

To perform a sound-alike match for the Last_name field of a table, first create an index using SOUNDEX( ):

index on soundex( LAST_NAME ) tag LAST_SNDX

Then to perform the search, use SOUNDEX( ) on the search value entered, like this:

function searchButton_onClick( )

   set order to LAST_SNDX 

   if not seek( soundex( form.soundsLike.value ) ) 

      msgbox( "No names similar", "Search failed" ) 

   endif