ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

STR function [String]

Function 

Returns the string equivalent of a number.

Syntax 

STR ( numeric_expression [, length [, decimal ] ] )

Parameters 

numeric-expression    Any approximate numeric (float, real, or double precision) expression between -1E126 and 1E127.

length    The number of characters to be returned (including the decimal point, all digits to the right and left of the decimal point, and blanks). The default is 10.

decimal    The number of decimal digits to be returned. The default is 0.

Usage 

If the integer portion of the number cannot fit in the length specified, then the result is a string of the specified length containing all asterisks. For example, the following statement returns ***

SELECT STR( 1234.56, 3 )

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

Example 

The following statement returns a string of six spaces followed by 1235, for a total of ten characters:

SELECT STR( 1234.56 )

The following statement returns the result 1234.6:

SELECT STR( 1234.56, 6, 1 )