SOUNDEX

SOUNDEX codifies text into a numeric string to allow mis-spelled or badly formatted data to be evaluated.

SOUNDEX( <field_name or tstring> [,< LANGUAGE > [,< LENGTH >]] )

  • field name or string: The field name or string value to which Soundex should be applied.

  • Language: Optional parameter:

    • 0 Indicates UK Soundex,

    • 1 Indicates French Soundex.

    • If left blank then UK is used.

  • Length: Integer value between 4 and 15. If left blank the default is 4.

Example: create a field on the CUSTOMER table that calculates the English SOUNDEX for the Surname field using 15 digits.

SOUNDEX( [Customer.SURNAME],0,15)