em desenvol tente into é feio... mas funciona
--sql2012 ou superior
Update [dbo].[ItemExtraFields] SET
[TextAnswer]=concat(substring([Description],1, charindex(' ', [Description])) , substring([Description],cast(charindex(' ', [Description])+1 as int)+cast(charindex(' ', substring([Description],cast(charindex(' ', [Description])+1 as int),len([Description]))) as int),len([Description])))
FROM [dbo].[ItemExtraFields] a
INNER JOIN [dbo].[ItemNames] b
on a.[ItemID]=b.[ItemID]
--sql2008 ou anterior
Update [dbo].[ItemExtraFields] SET
[TextAnswer]=substring([Description],1, charindex(' ', [Description])) + substring([Description],cast(charindex(' ', [Description])+1 as int)+cast(charindex(' ', substring([Description],cast(charindex(' ', [Description])+1 as int),len([Description]))) as int),len([Description]))
FROM [dbo].[ItemExtraFields] a
INNER JOIN [dbo].[ItemNames] b
on a.[ItemID]=b.[ItemID]