TSQL split string with ' '

Question

Possible Duplicate:
Split Function equivalent in tsql?

I have @FirstLastName = 'First Last'.

I need to split string in two variables @FirstName and @LastName.

In @FirstName goes 'First'.

In @LastName goes 'Last'.

Do you want something robust or will a combination of `CHARINDEX` + `SUBSTRING` suffice? — Marek Grzenkowicz, Jan 25 '13 at 10:32

score 1 · Accepted Answer · edited May 23 '17 at 11:56

This should do the trick but it's only a quick hack (SQL Fiddle):

SET @FirstName = substring(@FirstLastName
                         , 1
                         , charindex(' ', @FirstLastName)-1)

SET @LastName = substring(@FirstLastName
                        , charindex(' ', @FirstLastName)
                        , 999)

-- if you want to calculate the actual @LastName length,
-- replace 999 with len(@FirstLastName)-charindex(' ', @FirstLastName)+1

For a more elegant and robust way see Split function equivalent in T-SQL?.

TSQL split string with ' '

1 Answers1