>select sum(qtyshp) + @qtyord from pkpro..artran as a inner join icitem as i on a.item = i.item where custno = @custno and i.comcode = 'KR' and a.item like 'X%'
>
>
>I'm kinda stuck on this one, I'm not sure if this is right. I basically want to make sure that every a.item like 'X%' has a comcode of 'KR'. I think this is right....any help would be great! TIA!!!

It's not clear what result you want from this select.