I have used a function to parse data. It can be altered some to fit your needs.

select dbo.utilfn_split_get ('test me please', ' ', 2)

create function [dbo].[UTILfn_Split_Get](

@Stringnvarchar(4000),

@Delimiternvarchar(10),

@GetPosint

)

returns nvarchar(255)

begin

declare @NextString...