Class Soundex

Soundex is a database-specific algorithm that returns a phonetic representation of the argument string expression. These values should not be stored, only used in comparisons, in order to avoid problems when moving from one database to another.

Inheritance
object
QueryElement
Argument
ArgumentFunction
Soundex
Implements
Inherited Members
Namespace: SuperOffice.Data.SQL
Assembly: SoDataBase.dll
Syntax
public class Soundex : ArgumentFunction, ICloneable
Remarks

While the actual algorithm varies between databases, the return value is generally a short string, that is a coded representation of the phonetic properties of the string. Similar source strings will result in identical codes. More documentation can be found here:

Sybasehttp://dcx.sybase.com/1200/en/uladmin_en12/soundex-function.html
Oraclehttp://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm
SQL Serverhttp://msdn.microsoft.com/en-us/library/ms187384.aspx
Typical usage is to compare the soundex'es of two fields within a query. If they match, then the fields are the same or phonetically very close.

Constructors

Soundex(Argument)

Construct the query element, argument should be a field reference or another string-valued function

Declaration
public Soundex(Argument arg)
Parameters
Type Name Description
Argument arg
Remarks

While the actual algorithm varies between databases, the return value is generally a short string, that is a coded representation of the phonetic properties of the string. Similar source strings will result in identical codes. More documentation can be found here:

Sybasehttp://dcx.sybase.com/1200/en/uladmin_en12/soundex-function.html
Oraclehttp://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm
SQL Serverhttp://msdn.microsoft.com/en-us/library/ms187384.aspx
Typical usage is to compare the soundex'es of two fields within a query. If they match, then the fields are the same or phonetically very close.

Methods

Clone()

Deep clone of query element and argument

Declaration
public override object Clone()
Returns
Type Description
object
Overrides
Remarks

While the actual algorithm varies between databases, the return value is generally a short string, that is a coded representation of the phonetic properties of the string. Similar source strings will result in identical codes. More documentation can be found here:

Sybasehttp://dcx.sybase.com/1200/en/uladmin_en12/soundex-function.html
Oraclehttp://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm
SQL Serverhttp://msdn.microsoft.com/en-us/library/ms187384.aspx
Typical usage is to compare the soundex'es of two fields within a query. If they match, then the fields are the same or phonetically very close.

ToString()

ToString override for debugging

Declaration
public override string ToString()
Returns
Type Description
string
Overrides
Remarks

While the actual algorithm varies between databases, the return value is generally a short string, that is a coded representation of the phonetic properties of the string. Similar source strings will result in identical codes. More documentation can be found here:

Sybasehttp://dcx.sybase.com/1200/en/uladmin_en12/soundex-function.html
Oraclehttp://docs.oracle.com/cd/B19306_01/server.102/b14200/functions148.htm
SQL Serverhttp://msdn.microsoft.com/en-us/library/ms187384.aspx
Typical usage is to compare the soundex'es of two fields within a query. If they match, then the fields are the same or phonetically very close.

Implements

Extension Methods