selecting all columns

-- execution plan: http://dl.dropbox.com/u/2925840/ExecutionPlan3.png

SELECT * FROM SOP10100 AS Header
WHERE (Header.SOPTYPE = 2 OR Header.SopType = 5) --('Order','Back Order')
	  AND LEFT(Header.CUSTNMBR, 1) = '3'
	  --AND Status != 'COMPLETE'