I'm using SQL Express 2012, and I'm rather new to it so this website has been a blessing so far! I'm now stuck on a query that I've not found a suitable answer to.

I have a table called `Claims Passed`. In this I have a column called `Client_Name`, in this is a list of names, these contain first and second names split by a space (e.g John Smith). I've created two new columns, `Client_First_Name` and `Client_Surname`.

What I'm trying to do is get the get the first name in to first name column and the surname into the surname column.
I came across something like this but it was only for one row, not all the rows in one go.
How can i do this?