Tomar una palabra de un string en sql server

SELECT CASE CHARINDEX(' ', [campo], 1)
     WHEN 0 THEN [campo] -- empty or single word
     ELSE SUBSTRING([campo], 1, CHARINDEX(' ', [campo], 1) - 1) -- multi-word
END

FROM [tabla]