hi friends ,
the following query is working very fine .because i am getting rows when run
the following query in query analyzer.
Code:
SELECT IC_Itembarcode.itemID, IC_Itembarcode.Barcode, IC_Itembarcode.Serial1, IC_Itembarcode.Serial2, IC_Itembarcode.Serial3, IC_Itembarcode.Serial4, IC_Itembarcode.SerialCombination, IC_ItemID.L1Description, IC_ItemID.L2Description, IC_ItemID.ExtraL1Description, IC_ItemID.ExtraL2Description
FROM IC_ItemID INNER JOIN IC_Itembarcode 
ON IC_ItemID.itemID=IC_Itembarcode.itemID 
WHERE IC_iTEMID.ITEMID LIKE 'ADA-Mens-Accss-B%'
but when i change the where clause in my programme .because i want to restrict the rows on the basis of txtItemSearch .to get all the corresponding detail from ic_temid & ic_tembarcode tables.but the following query does not work.i am sure error is somewhere in where
clause .but i am unable to find it .let me know please .thx in advance .
Code:
 SELECT IC_Itembarcode.itemID, IC_Itembarcode.Barcode, IC_Itembarcode.Serial1, IC_Itembarcode.Serial2, IC_Itembarcode.Serial3, IC_Itembarcode.Serial4, IC_Itembarcode.SerialCombination, IC_ItemID.L1Description, IC_ItemID.L2Description, IC_ItemID.ExtraL1Description, IC_ItemID.ExtraL2Description
FROM IC_ItemID INNER JOIN IC_Itembarcode 
ON IC_ItemID.itemID=IC_Itembarcode.itemID 
WHERE IC_ItemID.itemid  Like ' & Trim(txtItemSearch.Text) &% '