Searching by describtion

Question

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

Pat Tum · Answer

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