SAID

SAID, SPOKEN, ~

Top  Previous  Next

 

The SAID selection clause operator compares a field or evaluated expression against another field, evaluated expression or literal value and tests for the first item having the Soundex phonetic code given by the second. The synonyms SPOKEN and ~ can be used.

 

 

Format

 

field SAID value

 

where

 

fieldis the first field or evaluated expression to be compared.

 

valueis the second field, evaluated expression or literal value to be compared.

 

 

The SAID selection clause operator returns True if the Soundex phonetic code for field is value.

 

The Soundex phonetic code for a word is made up from the first letter of the word in upper case followed by three digits which are found by examination of further characters of the word according to the following table.

 

0A  E  H  I  O  U  W  Y
1B  F  P  V
2C  G  J  K  Q  S  X  Z
3D  T
4L
5M  N
6R

 

Other letters are ignored. Consecutive letters that result in the same value result in only a single character. If the result is less than four characters long, zeros are added to fill the remaining positions. Thus the word SOUNDEX encodes to S532.

 

 

Example

 

LIST STAFF WITH SURNAME SAID 'REED'

 

This command names in the STAFF file that sound like Reed (Read, Reid, etc).