Sybase Adaptive Server Anywhere - Page 384

Alphabetical list of functions
366
"ASIN function" on page 314
"COS function" on page 323
"COT function" on page 324
"TAN function" on page 370
SOUNDEX function [String]
Returns a number representing the sound of a string.
SOUNDEX ( string-expression )
string-expression The string.
The following statement returns two numbers, representing the sound of each
name. The SOUNDEX value for each argument is 3827.
SELECT SOUNDEX( ’Smith’ ), SOUNDEX( ’Smythe’ )
The SOUNDEX function value for a string is based on the first letter and the
next three consonants other than H, Y, and W. Doubled letters are counted as
one letter. For example,
SOUNDEX( ’apples’ )
is based on the letters A, P, L and S.
Multi-byte characters are ignored by the SOUNDEX function.
Although it is not perfect, soundex will normally return the same number for
words that sound similar and that start with the same letter.
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise, except that
Adaptive Server Enterprise returns a CHAR(4) result and Adaptive
Server Anywhere returns an integer.
SPACE function [Miscellaneous]
Returns a specified number of spaces.
SPACE ( integer-expression )
integer expression The number of spaces to return.
The following statement returns a string containing 10 spaces.
SELECT SPACE( 10 )
See also
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
Function
Syntax
Parameters
Examples