Hello am trying to select data from my database where value

Question

Hello I am trying to select data from my access database where column particulars is like value in my textbox1.text However column particulars in my database is memo data type. This is the code am using but in vain. Select from database where particulars like '%" + textbox.text +"%' Plse any help will b appreciated

Bikesh Srivastava · Answer

Hi I think you are doing good but you need to change some little bit of code can you share your code waht you tried

Nilesh Shah · Answer

I think you are missing a * in like either we use ? for one character or * for more than one characters Select from database where particulars like '% + textbox.text +%' should be Select from database where particulars like '* + textbox.text +*'