SQL substring question

Transact-SQL
4 
SELECT string, CASE WHEN string NOT LIKE '%.%.%' THEN string
    ELSE LEFT(string, CHARINDEX('.', string + '.', CHARINDEX('.', string + '.') + 1) - 1) END
FROM #data
1 Like