Chapter 8 SQL Functions
369
The following statement returns the value chocolate pie.
SELECT STUFF( ’chocolate cake’, 11, 4, ’pie’ )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"INSERTSTR function" on page 341
SUBSTRING function [String]
Returns a substring of a string.
{ SUBSTRING | SUBSTR }(
string-expression
,
start
[,
length
] )
string-expression The string from which a substring is to be returned.
start The start position of the substring to return, in characters. A negative
starting position specifies a number of characters from the end of the string
instead of the beginning. The first character in the string is at position 1.
length The length of the substring to return, in characters. A positive
length specifies that the substring ends length characters to the right of the
starting position, while a negative length specifies that the substring ends
length characters to the left of the starting position.
The following statement returns back:
SELECT SUBSTRING( ’back yard’,1 ,4 )
The following statement returns yard:
SELECT SUBSTRING( ’back yard’, -1 , -4 )
If length is specified, the substring is restricted to that length. If no length is
specified, the remainder of the string is returned, starting at the start position.
Both start and length can be negative. Using appropriate combinations of
negative and positive numbers, you can get a substring from either the
beginning or end of the string.
If string-expression is of binary data type, the SUBSTRING function
behaves as BYTE_SUBSTR.
♦
SQL/92 Vendor extension.
♦
Sybase SUBSTRING is compatible with Adaptive Server Enterprise.
SUBSTR is not supported by Adaptive Server Enterprise.
"BYTE_SUBSTR function" on page 317
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Usage
Standards and
compatibility
See also
To Next Page
Loading...