Type:
Scalar function
This function returns a substring starting at the @StartIndex and ending at the end of the string.
Only use this for single values or where performance is not important. Otherwise use built-in SUBSTRING or STUFF for similar functionality.
SUBSTRING(@Text, @StartIndex, LEN(@Text) - @StartIndex + 1)
STUFF(@Text, 1, @StartIndex - 1, '')
Return value: nvarchar(max)
Returns a substring starting at the specified index.
Parameters
@Str
mandatory
nvarchar(max)
The original string.
@StartInde
mandatory
int
Specifies the start index.