SqlFunctions.Stuff Method
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.
Assembly: System.Data.Entity (in System.Data.Entity.dll)
'Declaration <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.
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).
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
