- CREATE FUNCTION [dbo].[svf_GetSplitRightString] (
- @InputString NVARCHAR(4000) ,
- @DelimitPosition CHAR(1)
- )
- RETURNS NVARCHAR(4000)
- AS
- BEGIN
- DECLARE @RtvString NVARCHAR(4000)
- SET @RtvString = RTRIM(@InputString)
- WHILE CHARINDEX(@DelimitPosition, @RtvString ) <> 0
- BEGIN
- SET @RtvString = RIGHT(@RtvString, LEN(@RtvString) - CHARINDEX (@DelimitPosition, @RtvString) )
- END
- RETURN @RtvString
- END