Given that your name column contains this format
[Firstname][space][LastName]
You can use CHARINDEX and SUBSTRING to split it into 2 columns. The following is an example
DECLARE @name AS VARCHAR(30)
DECLARE @spaceIndex AS INT
SET @name = 'Walter Hevedeich'
SET @spaceIndex = CHARINDEX(' ', @name)
SELECT SUBSTRING(@name, 1, @spaceIndex) AS FirstName,
SUBSTRING(@name,@spaceIndex,LEN(@name)) AS LastName
Also, check
this[
^] link for the complete string functions for SQL.