Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
String-Manipulation FunctionsString-manipulation functions perform various operations on strings of characters.
SOUNDEX FunctionThis function returns a 4-character code which can be used to compare with the sound of other strings. The code represents the sound of the words in the argument.

SOUNDEX Function

This function returns a 4-character code which can be used to compare with the sound of other strings. The code represents the sound of the words in the argument.

The SOUNDEX function has this syntax:

SOUNDEX Function


Element	Description	Syntax
source_string	String of characters argument to the SOUNDEX function	Must be an expression, constant, column, or host variable of a data type that can be converted to a character data type

The data type of the return value is CHAR(4). If the argument is null, then the result is the null value.

Use this fuction to find the strings for which the sound is known but the actual spelling is not known. This funtion converts the given expression into a four-digit code based on the sound of the expression .