$soundex

$soundex

Welcome to our Knowledge Base

Documentation | Blog | Demos | Support

< All Topics
Print

$soundex

Generates the “sounds-like” value of a string.

Syntax

$soundex(source)

Parameters

sourcea character string, or an expression that evaluates to a character string

Return Value

Character string (alpha).

Comments

$soundex yields a “sounds-like” value for source. The value is created using an heuristic algorithm and is based on English pronunciation.

When $soundex is applied to two separate strings and they generate the same “sounds-like” value, then the two original strings can be assumed to sound the same. $soundex can be used to compare and find strings that sound the same but are spelled differently.

The result of $soundex is of data type ALPHA, therefore comparisons involving soundex values are case-insensitive.

Example

find all Customers where $soundex(LastName) = $soundex("Burton")

The above command returns customer records for names like Burton, Berton, Bertyn, Bertin, BURTON, BERTIN, and so on.

find all Customers where sLastName = $soundex("Burton")

The preceding command takes advantage of indexed searching by setting up sLastName as an indexed virtual field that contains the soundex values of LastName in the Customers EntitySet.

let SoundsLike = $soundex("Smith")
find all Customers where sLastName = SoundsLike?

The preceding code fragment uses prefix searching (? wildcard) with soundex values.

See Also

? (Wildcard)

About Character Literals

About Functional Expressions

Was this article helpful?
0 out of 5 stars
5 Stars 0%
4 Stars 0%
3 Stars 0%
2 Stars 0%
1 Stars 0%
5
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

pt_BRPortuguese