Loading

Searching by describtion

islam negm

Hi all I'm using the ms access2003 with the c# i need to search by a describtion of a specific produc in my application now i have to use the LIKE word in my query, but i'm facing a problem of how to pass the parameter of the word after LIKE word I primarily used this SQLQuery "SELECT Med_ID, Med_Name, Med_Backet_Type, Med_Unit_Type, Med_Group, Med_Place, Med_SalePrice, Med_BuyPrice, Med_Backet_qty, Med_Unit_qty FROM Medicine WHERE Med_effect_desc LIKE %?" But there is a syntax error. Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Pat Tum19y ago
Hello, When using the SQl tool LIKE, you must supply a keyword in addition to the "per cent" sign. So, for example, if you want to find a medical effect that includes the words "migrane headache", a search that would produce this result could be %headache. Likewise, Migrane% would also work. You could also do %head%, and that would also bring up this result. Remember, the % tool is used to locate a "string" of information within a word or group of words. Good Luck...Pat