Sql statement Issue

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) &% '

---

"WHERE IC_ItemID.itemid Like '" & Trim(txtItemSearch.Text) & "%'"

Thread moved to the 'Database Development' forum (the 'VB6' forum is only meant for questions which don't fit in more specific forums)

normally if it is string then we are doing filtervariable inside the ' '.but i did not understand .why " " is also needed here .:)

Quote:

---

Originally Posted by firoz.raj

normally if it is string then we are doing filtervariable inside the ' '.but i did not understand .why " " is also needed here .:)

---

If you Debug.Print your sql statement, you will see why