Here is the K.I.S.S. Version...

SELECT *, CASE WHEN(CHARINDEX(' ',test)=0) THEN test ELSE LEFT(test,CHARINDEX(' ',test)) END FROM tablename

This should work for you.