STUFF function [String]

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

Syntax 
STUFF( string-expression-1, start, length, string-expression-2 )
Parameters

  • string-expression-1   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-expression-2   The string to be inserted. To delete a portion of a string using the STUFF function, use a replacement string of NULL.

Remarks

This function supports NCHAR inputs and/or outputs.

See also
Standards and compatibility

  • SQL/2003   Vendor extension.

Example

The following statement returns the value chocolate pie.

SELECT STUFF( 'chocolate cake', 11, 4, 'pie' );
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0