Sybase Adaptive Server Anywhere - Page 378

Alphabetical list of functions
360
REMAINDER function [Numeric]
Returns the remainder when one whole number is divided by another.
REMAINDER ( dividend , divisor )
dividend The dividend, or numerator of the division.
divisor The divisor, or denominator of the division.
The following statement returns the value 2
.
SELECT REMAINDER( 5, 3 )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise. The % (modulo)
operator and the division operator can be used to produce a remainder.
"MOD function" on page 349
REPEAT function [String]
Concatenates a string a specified number of times.
REPEAT ( string-expression , integer-expression )
string-expression The string to be repeated.
integer-expression The number of times the string is to be repeated. If
integer-expression is negative, an empty string is returned.
The following statement returns the value repeatrepeatrepeat.
SELECT REPEAT( ’repeat’, 3 )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise, but
REPLICATE provides the same capabilities.
"REPLICATE function" on page 361
REPLACE function [String]
Replaces all occurrences of a substring with another substring.
REPLACE ( original-string , search-string , replace-string )
If any argument is NULL, the function returns NULL.
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters