t-sql get first item from list using substring and charindex

tsql_GetFirstItemFromListUsingSubstringAndCharIndex

DECLARE @InvalidList varchar(50)
DECLARE @ValidList varchar(50)
SET @InvalidList = 'Item1-Item2-Item3'
SET @ValidList = 'Item1 > Item2 > Item3'
 
SELECT
        CASE
                WHEN CHARINDEX('>',@InvalidList) = 0 THEN @InvalidList
                ELSE LTRIM(RTRIM(REPLACE(SUBSTRING(@InvalidList,1,CHARINDEX('>',@InvalidList)),'>','')))
        END
 
SELECT
        CASE
                WHEN CHARINDEX('>',@ValidList) = 0 THEN @ValidList
                ELSE LTRIM(RTRIM(REPLACE(SUBSTRING(@ValidList,1,CHARINDEX('>',@ValidList)),'>','')))
        END