This might appeal to someone it is based on work above:

IIF(charindex(' ', [YouColumn]) = 0, LEFT([YourColumn], LEN([YourColumn])), LEFT([YourColumn], charindex(' ', [YourColumn]) - 1)) AS NewColumnName

Sometime IIF is cleaner than CASE.