ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

STUFF function [String]

Function 

Deletes a number of characters from one string and replaces them with another string.

Syntax 

STUFF ( string-expression1, start, length, string-expression2 )

Parameters 

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 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Compatible with Adaptive Server Enterprise.

See also 

INSERTSTR function [String]

Example 

The following statement returns the value chocolate pie.

SELECT STUFF( 'chocolate cake', 11, 4, 'pie' )