SELECT 
    ValueColumn AS OriginalValue,
    LTRIM(SUBSTRING(ValueColumn, CHARINDEX('.zzz-', ValueColumn) + 5, LEN(ValueColumn))) AS AfterZZZ
FROM ExampleValues;