Sybase Adaptive Server Anywhere - Page 390

Alphabetical list of functions
372
To use the traceback function, enter the following after an error occurs while
executing a procedure:
SELECT TRACEBACK ( * )
This is useful for debugging procedures and triggers
♦
SQL/92 Transact-SQL extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
TRIM function [String]
Removes leading and trailing blanks from a string.
TRIM ( string-expression )
string-expression The string to be trimmed.
The following statement returns the value chocolate with no leading or
trailing blanks.
SELECT TRIM( ’ chocolate ’ )
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"LTRIM function" on page 347
"RTRIM function" on page 363
TRUNCATE function [Numeric]
Truncates a number at a specified number of places after the decimal point.
Deprecated in favor of TRUNCNUM.
"TRUNCATE" ( numeric-expression , integer-expression )
numeric-expression The number to be truncated.
integer-expression A positive integer specifies the number of significant
digits to the right of the decimal point at which to round. A negative
expression specifies the number of significant digits to the left of the decimal
point at which to round.
The following statement returns the value 600
SELECT "TRUNCATE"( 655, -2 )
The following statement returns the value 655.340.
Examples
Usage
Standards and
compatibility
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples