• No Worries, Found a Link that helped.

    LTRIM(LEFT(p.Delivery_Site, CHARINDEX(' ',p.Delivery_Site)))