Sql statement Issue

[firoz.raj]

hi friends ,
the following query is working very fine .because i am getting rows when run
the following query in query analyzer.

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 .

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

[LaVolpe]

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

[si_the_geek]

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

[firoz.raj]

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

[LaVolpe]

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