SELECT "dbo"."StockItem"."Code", "dbo"."StockItem"."Name", "dbo"."StockItem"."TaxCodeID", "dbo"."StockItem"."PartNumber", "StockItemPrice"."Price" FROM "dbo"."StockItem" , "StockItemPrice" WHERE "dbo"."StockItem"."ItemID" = "StockItemPrice"."ItemID" AND ("StockItemPrice"."PriceBandID" = 1001 AND "dbo"."StockItem"."Code" LIKE '6%' AND "dbo"."StockItem"."PartNumber" LIKE '%?BarcodeSearch1%' AND "dbo"."StockItem"."Name" LIKE '%?NameSearch%' AND "dbo"."StockItem"."TaxCodeID" = 258