Share via


SqlCeFunctions.Stuff Method

Definition

Inserts a string into another string. It deletes a specified length of characters in the target string at the start position and then inserts the second string into the target string at the start position.

[System.Data.Entity.DbFunction("SqlServerCe", "STUFF")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1720:IdentifiersShouldNotContainTypeNames", MessageId="string")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="stringReplacement")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="start")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="length")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="stringInput")]
public static string Stuff (string stringInput, Nullable<int> start, Nullable<int> length, string stringReplacement);
static member Stuff : string * Nullable<int> * Nullable<int> * string -> string
Public Shared Function Stuff (stringInput As String, start As Nullable(Of Integer), length As Nullable(Of Integer), stringReplacement As String) As String

Parameters

stringInput
String

The target string.

start
Nullable<Int32>

The character position in stringinput where the replacement string is to be inserted.

length
Nullable<Int32>

The number of characters to delete from stringInput . If length is longer than stringInput , deletion occurs up to the last character in stringReplacement .

stringReplacement
String

The substring to be inserted into stringInput .

Returns

A string consisting of the two strings.

Attributes

Applies to