Here's an approach using Chris Morris Pattern Splitter:

select Delivery_Site, firstword.Item

from p

cross apply (

select top 1 * from dbo.PatternSplitCM(Delivery_Site, '%[a-z0-9]%')

where Matched = 1

order by ItemNumber

) firstword

[/url]