This is not pretty but it should work:
select
(
case isnull(stock.StockName,'')
when '' then '' else stock.StockName + '-' end
+
case isnull(manu.ManufacturerName,'')
when '' then '' else manu.ManufacturerName + '-' end
+
case isnull(brand.BrandName,'')
when '' then '' else brand.BrandName + '-' end
+
case isnull(model.ModelName,'')
when '' then '' else model.ModelName + '-' end
) Stockitems