ALTER FUNCTION fn_clean_Name_Split (@source VARCHAR(255))
RETURNS VARCHAR(255)
AS
BEGIN
    DECLARE @target VARCHAR(255) = @source
    DECLARE @index INT = CHARINDEX(' ',@target)

    SET @target =
        CASE
            WHEN @index <> LEN(@target)
            THEN LEFT(@target, @index)
        END AS FirstName,
        CASE
            WHEN @index <> LEN(@target) - CHARINDEX(' ', REVERSE(@target)) + 1
            THEN SUBSTRING(@target, @index + 1, LEN(@target) - CHARINDEX(' ', REVERSE(@target)) - @index)
        END AS MI,
        CASE
            WHEN @index <> LEN(@target) - @index + 1
            THEN RIGHT(@target, CHARINDEX(' ', REVERSE(@target))) AS LastName,
            ELSE @target

    SET @target = dbo.fn_standardize_CamelCase(@target)

    RETURN @target
END