Show TOC

SOUNDS Predicate (sounds_predicate)Locate this document in the navigation structure

Use

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

Structure
				
<sound_predicate>::=
  <expression> [NOT] SOUNDS [LIKE] <expression>

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, 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