Sybase Adaptive Server Anywhere - Page 386

Alphabetical list of functions
368
♦
SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
STRING function [String]
Concatenates one or more strings into one large string.
STRING ( string-expression [, ...] )
string-expression A string.
If only one argument is supplied, it is converted into a single expression. If
more than one argument is supplied, they are concatenated into a single
string.
A NULL is treated as an empty string (’’).
The following statement returns the value testing123
.
SELECT STRING( ’testing’, NULL, 123 )
Numeric or date parameters are converted to strings before concatenation.
The STRING function can also be used to convert any single expression to a
string by supplying that expression as the only parameter.
If all parameters are NULL, STRING returns NULL.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
STUFF function [String]
Deletes a number of characters from one string and replaces them with
another string.
STUFF ( string-expression1 , start , length , string-expression2 )
string-expression1 The string to be modified by the STUFF function.
start The character position at which to begin deleting characters. The first
character in the string is position 1.
length The number of characters to delete.
string-expression2 The string to be inserted. To delete a portion of a
string using STUFF, use a replacement string of NULL.
Standards and
compatibility
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
Function
Syntax
Parameters