SqlFunctions.Stuff Method (String, Nullable(Of Int32), Nullable(Of Int32), String)

.NET Framework (current version)
 

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.

Namespace:   System.Data.Objects.SqlClient
Assembly:  System.Data.Entity (in System.Data.Entity.dll)

<EdmFunctionAttribute("SqlServer", "STUFF")>
Public Shared Function Stuff (
	stringInput As String,
	start As Nullable(Of Integer),
	length As Nullable(Of Integer),
	stringReplacement As String
) As String

Parameters

stringInput
Type: System.String

The target string.

start
Type: System.Nullable(Of Int32)

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

length
Type: System.Nullable(Of 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
Type: System.String

The substring to be inserted into stringInput.

Return Value

Type: System.String

A string consisting of the two strings.

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STUFF (Transact-SQL).

.NET Framework
Available since 4.0
Return to top
Show: