UPDATE SET TITLE = TITLE.Split(' ')[0]

UPDATE yourTable
SET TITLE = CASE WHEN CHARINDEX(' ', TITLE) > 0
                 THEN SUBSTRING(TITLE, 1, CHARINDEX(' ', TITLE) - 1)
                 ELSE TITLE END;