STUFF function [String]

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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite SQL functions » Functions

STUFF function [String]

Deletes multiple 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.

Returns

See also

Example

Discuss this page in DocCommentXchange.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0