Sybase Adaptive Server Anywhere - Page 383

Chapter 8 SQL Functions
365
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
SIMILAR function [String]
Returns a number indicating the similarity between two strings.
SIMILAR ( string-expression-1 , string-expression-2 )
string-expression-1 The first string to be compared.
string-expression-2 The second string to be compared.
The following statement returns the value 75.
SELECT SIMILAR( ’toast’, ’coast’ )
This signifies that the two values are 75% similar.
The function returns an integer between 0 and 100 representing the similarity
between the two strings. The result can be interpreted as the percentage of
characters matched between the two strings. A value of 100 indicates that the
two strings are identical.
This function can be used to correct a list of names (such as customers).
Some customers may have been added to the list more than once with
slightly different names. Join the table to itself and produce a report of all
similarities greater than 90 percent but less than 100 percent.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
SIN function [Numeric]
Returns the sine of a number.
SIN ( numeric-expression )
numeric-expression The angle, in radians.
The following statement returns the value 0.496880.
SELECT SIN( 0.52 )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
Standards and
compatibility
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
Function
Syntax
Parameters
Examples
Standards and
compatibility