Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL function reference » Alphabetical list of functions


STUFF function [String]

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

STUFF( string-expression-1, start, length, string-expression-2 )
  • 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.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.


The following statement returns the value chocolate pie.

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