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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

STRTOUUID function [String] Next Page

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

The following statement returns the value chocolate pie.

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