Show TOC

Background documentationSOUNDS Predicate (sounds_predicate)

 

A SOUNDS predicate (sounds_predicate) is used to perform a phonetic comparison.

Structure

Syntax Syntax

  1. <sound_predicate> ::=
  <expression> [NOT] SOUNDS [LIKE] <expression>
End of the code.
Explanation

Specifying LIKE in the SOUNDS predicate has no effect. The values in the expressions (expression) must be alphanumeric (code attribute ASCII).

A phonetic comparison between values is carried out according to the SOUNDEX algorithm. First, all vowels and some consonants are eliminated, then all consonants which are similar in sound are mapped to each other.

x [NOT] SOUNDS [LIKE] y

x, y

Result of the Predicate

x or y is the NULL value

x SOUNDS y is undefined

x and y are non-NULL values

x SOUNDS y is true or false

x and y are phonetically identical

x SOUNDS y is true

x NOT SOUNDS y has the same result as NOT (x SOUNDS y).

More Information

SOUNDEX(x) string function