Type: Scalar function

This function takes a string and removes any trailing substring that matches the supplied trail-parameter.

If the substring is repeated several times in the trail of the string, then all of these occurrences will be removed.


@str mandatory nvarchar(max)
The string in which to remove the trailing substring
@trail mandatory nvarchar(max)
The trailing substring to be removed