Sean, Your code looses the last value in the string, for value 'asdf12345678901' you loose the 1.
That's wierd I'm having trouble posing code now, Oh well.
Added a 1 + to the substring will take care of that.
SUBSTRING(p.Delivery_Site, 0, 1 + case when CHARINDEX(' ', p.Delivery_Site) = 0 then LEN(p.Delivery_Site) else CHARINDEX(' ', p.Delivery_Site) end) as NewVersion
-------------------------------------------------------------
we travel not to escape life but for life not to escape us
Don't fear failure, fear regret.