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

SQL Anywhere 11.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (P-Z)


STUFF function [String]

Deletes multiple 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' );