Hi Friends, Can anyone send a correct Sql query embdedded in servlet code for wild card search with MSAcess database. Kindly test it as It is not working after trying it for many times. It works fine with oracle database but not with MSAccess. bye, shiva
posted 16 years ago
I have used the SQL construct "... like '%...%' ..." successfully in Access. Is that what you are looking for?
posted 15 years ago
Hi Brian, Thanks for the feedback. But u know I need to embed this is in the servlet. That is where the problem is. Directly with MSAccess it works fine. Let me once u successfully do it embedding in servlet. Thanks, shiva