SqlFunctions.Stuff Method

Definition

Namespace:

System.Data.Entity.SqlServer

Assembly:

EntityFramework.SqlServer.dll

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("SqlServer", "STUFF")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="start")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="stringInput")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="stringReplacement")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Naming", "CA1720:IdentifiersShouldNotContainTypeNames", MessageId="string")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="length")]
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

String

A string consisting of the two strings.

Attributes

DbFunctionAttribute SuppressMessageAttribute