Deprecated. Don't use for new development and try to migrate existing uses.

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