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.
Parameters
@str
mandatory
nvarchar(max)
The string in which to remove the trailing substring
@trail
mandatory
nvarchar(max)
The trailing substring to be removed