Alphabetical list of functions
374
UCASE (
string-expression
)
string-expression The string to be converted to upper case.
The following statement returns the value CHOCOLATE.
SELECT UCASE( ’ChocoLate’ )
♦ SQL/92 Vendor extension.
♦
Sybase UCASE is not supported by Adaptive Server Enterprise, but
UPPER provides the same feature in a compatible manner.
"UPPER function" on page 374
"LCASE function" on page 343
UPPER function [String]
Converts all characters in a string to upper case.
UPPER (
string-expression
)
string-expression The string to be converted to upper case.
The following statement returns the value CHOCOLATE.
SELECT UPPER( ’ChocoLate’ )
♦ SQL/92 This function is SQL/92 compatible.
♦
Sybase Compatible with Adaptive Server Enterprise.
"UCASE function" on page 373
"LCASE function" on page 343
"LOWER function" on page 346
WEEKS function [Date and time]
Returns the number of weeks since an arbitrary date and time, between two
specified times, or adds the specified integer-expression amount of weeks to
a datetime.
WEEKS (
datetime-expression
|
datetime-expression, datetime-expression
|
datetime-expression, integer-expression
)
datetime-expression A date and time.
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
To Next Page
Loading...